/ BBS in a Box 5 / BBS in a Box -Volume V (BBS in a Box) (April 1992).iso / Files / Bus / N-Q / Optima.cpt / Best Answer™ Demo.rsrc

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 05 16 07 00 02 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 02 00 00 00 09 00 00 |........|........|
|00000020| 00 32 00 00 00 20 00 00 | 00 02 00 00 00 52 00 01 |.2... ..|.....R..|
|00000030| d0 2a 41 50 50 4c 42 45 | 53 54 21 00 00 00 00 00 |.*APPLBE|ST!.....|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 01 00 00 01 | c5 50 00 01 c4 50 00 00 |........|.P...P..|
|00000060| 0a da 00 00 01 ff ff ff | ff 80 00 00 01 80 00 00 |........|........|
|00000070| 01 80 00 00 01 ff ff ff | ff 80 00 00 01 80 00 00 |........|........|
|00000080| 01 80 11 42 65 73 74 20 | 41 6e 73 77 65 72 aa 20 |...Best |Answer. |
|00000090| 44 65 6d 6f 02 00 00 00 | 41 50 50 4c 42 45 53 54 |Demo....|APPLBEST|
|000000a0| 20 00 00 00 41 50 50 4c | 42 45 53 54 20 00 00 00 | ...APPL|BEST ...|
|000000b0| 00 40 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.@......|........|
|000000c0| 00 00 00 00 9d e1 bd 16 | 00 00 00 00 00 01 d0 2a |........|.......*|
|000000d0| 01 80 00 00 01 ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000000e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000000f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000100| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000110| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000120| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000130| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000140| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000150| ff ff 00 00 00 01 00 00 | 00 00 1c 42 45 53 54 00 |........|...BEST.|
|00000160| 00 00 01 49 43 4e 23 00 | 00 00 00 04 4c 46 52 45 |...ICN#.|....LFRE|
|00000170| 46 00 00 00 00 04 4c 00 | 00 00 07 41 50 50 4c 00 |F.....L.|...APPL.|
|00000180| 00 00 00 00 01 00 88 88 | 88 88 88 88 88 88 88 88 |........|........|
|00000190| 88 88 88 88 88 88 8c 88 | 88 88 cc c8 88 88 cc cc |........|........|
|000001a0| 88 88 cc cc 88 88 cc cc | 88 88 cc cc c8 88 cc cc |........|........|
|000001b0| c8 88 cc cc c8 88 cc cc | c8 88 cc cc c8 88 cc cc |........|........|
|000001c0| c8 88 cc cc c8 88 cc cc | c8 88 cc cc c8 88 cc cc |........|........|
|000001d0| c8 88 cc cc c8 88 cc cc | c8 88 ec cc c8 88 ec cc |........|........|
|000001e0| c8 88 ee ce c8 88 ee ee | 88 88 ee ee 88 88 ee ec |........|........|
|000001f0| 88 88 ee e8 88 88 8e 88 | 88 88 88 88 88 88 88 88 |........|........|
|00000200| 88 88 88 88 88 88 ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000210| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000220| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000230| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000240| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000250| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000260| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000270| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000280| ff ff ff ff ff ff 00 00 | 00 0c 00 44 00 50 00 b9 |........|...D.P..|
|00000290| 01 ae 4a 38 55 55 00 00 | 00 2c 01 0e ff ff 01 1e |..J8UU..|.,......|
|000002a0| 01 df 00 01 01 00 00 02 | 00 01 00 10 00 00 00 00 |........|........|
|000002b0| 15 68 6f 72 69 7a 6f 6e | 74 61 6c 20 73 63 72 6f |.horizon|tal scro|
|000002c0| 6c 6c 20 62 61 72 00 00 | 00 2a ff ff 01 de 01 0f |ll bar..|.*......|
|000002d0| 01 ee 00 01 01 00 00 02 | 00 01 00 10 00 00 00 00 |........|........|
|000002e0| 13 76 65 72 74 69 63 61 | 6c 20 73 63 72 6f 6c 6c |.vertica|l scroll|
|000002f0| 20 62 61 72 00 00 00 48 | 03 e7 00 00 00 00 00 00 | bar...H|........|
|00000300| 00 00 00 00 d2 fb 04 45 | 64 69 74 04 55 6e 64 6f |.......E|dit.Undo|
|00000310| 00 5a 00 00 01 2d 00 00 | 00 00 03 43 75 74 00 58 |.Z...-..|...Cut.X|
|00000320| 00 00 04 43 6f 70 79 00 | 43 00 00 05 50 61 73 74 |...Copy.|C...Past|
|00000330| 65 00 56 00 00 05 43 6c | 65 61 72 00 00 00 00 00 |e.V...Cl|ear.....|
|00000340| 00 00 00 0a 80 00 00 03 | 00 00 00 01 80 00 00 00 |........|........|
|00000350| 00 0e 0d 4d 61 78 69 6d | 69 7a 69 6e 67 2e 2e 2e |...Maxim|izing...|
|00000360| 00 00 00 0e 0d 4d 69 6e | 69 6d 69 7a 69 6e 67 2e |.....Min|imizing.|
|00000370| 2e 2e 00 00 00 87 03 e6 | 00 00 00 00 00 00 00 00 |........|........|
|00000380| ff ff ff ff 06 46 6f 72 | 6d 61 74 0a 39 2e 39 39 |.....For|mat.9.99|
|00000390| 39 39 65 2b 39 39 00 45 | 00 00 01 39 00 30 00 00 |99e+99.E|...9.0..|
|000003a0| 03 39 2e 39 00 31 00 00 | 04 39 2e 39 39 00 32 00 |.9.9.1..|.9.99.2.|
|000003b0| 00 05 39 2e 39 39 39 00 | 33 00 00 06 39 2e 39 39 |..9.999.|3...9.99|
|000003c0| 39 39 00 34 00 00 07 39 | 2e 39 39 39 39 39 00 35 |99.4...9|.99999.5|
|000003d0| 00 00 08 39 2e 39 39 39 | 39 39 39 00 36 00 00 09 |...9.999|999.6...|
|000003e0| 39 2e 39 39 39 39 39 39 | 39 00 37 00 00 0a 39 2e |9.999999|9.7...9.|
|000003f0| 39 39 39 39 39 39 39 39 | 00 38 00 00 00 00 00 00 |99999999|.8......|
|00000400| 15 00 7e 00 80 00 bc 01 | 70 00 01 01 00 00 00 00 |..~.....|p.......|
|00000410| 00 00 00 17 70 00 00 00 | 00 50 00 03 00 00 00 00 |....p...|.P......|
|00000420| 00 08 00 98 00 1c 00 d4 | 04 02 4f 4b 00 00 00 00 |........|..OK....|
|00000430| 00 24 00 98 00 38 00 d4 | 04 06 43 61 6e 63 65 6c |.$...8..|..Cancel|
|00000440| 00 00 00 00 00 18 00 04 | 00 28 00 4d 88 0c 47 6f |........|.(.M..Go|
|00000450| 20 74 6f 20 63 65 6c 6c | 3a 20 00 00 00 00 00 18 | to cell|: ......|
|00000460| 00 53 00 28 00 7d 90 02 | 41 31 00 00 00 1e 1d 54 |.S.(.}..|A1.....T|
|00000470| 6f 6f 20 6d 61 6e 79 20 | 63 65 6c 6c 73 20 77 65 |oo many |cells we|
|00000480| 72 65 20 73 65 6c 65 63 | 74 65 64 2e 00 00 00 32 |re selec|ted....2|
|00000490| 31 41 64 6a 75 73 74 61 | 62 6c 65 20 63 65 6c 6c |1Adjusta|ble cell|
|000004a0| 73 20 63 61 6e 20 6f 6e | 6c 79 20 63 6f 6e 74 61 |s can on|ly conta|
|000004b0| 69 6e 20 6e 75 6d 65 72 | 69 63 20 76 61 6c 75 65 |in numer|ic value|
|000004c0| 73 2e 00 00 00 2d 2c 43 | 6f 6e 73 74 72 61 69 6e |s....-,C|onstrain|
|000004d0| 74 20 63 65 6c 6c 73 20 | 63 61 6e 20 6f 6e 6c 79 |t cells |can only|
|000004e0| 20 63 6f 6e 74 61 69 6e | 20 61 20 66 6f 72 6d 75 | contain| a formu|
|000004f0| 6c 61 2e 00 00 00 2b 2a | 4f 62 6a 65 63 74 69 76 |la....+*|Objectiv|
|00000500| 65 20 63 65 6c 6c 20 63 | 61 6e 20 6f 6e 6c 79 20 |e cell c|an only |
|00000510| 63 6f 6e 74 61 69 6e 20 | 61 20 66 6f 72 6d 75 6c |contain |a formul|
|00000520| 61 2e 00 00 00 39 38 49 | 6e 76 61 6c 69 64 20 53 |a....98I|nvalid S|
|00000530| 59 4c 4b 20 70 61 72 6d | 20 65 6e 63 6f 75 6e 74 |YLK parm| encount|
|00000540| 65 72 65 64 20 77 68 69 | 6c 65 20 72 65 61 64 69 |ered whi|le readi|
|00000550| 6e 67 20 73 70 72 65 61 | 64 73 68 65 65 74 2e 00 |ng sprea|dsheet..|
|00000560| 00 00 3e 3d 49 6e 76 61 | 6c 69 64 20 58 2c 59 20 |..>=Inva|lid X,Y |
|00000570| 63 6f 6f 72 64 69 6e 61 | 74 65 20 65 6e 63 6f 75 |coordina|te encou|
|00000580| 6e 74 65 72 65 64 20 77 | 68 69 6c 65 20 72 65 61 |ntered w|hile rea|
|00000590| 64 69 6e 67 20 73 70 72 | 65 61 64 73 68 65 65 74 |ding spr|eadsheet|
|000005a0| 2e 00 00 00 3e 3d 4e 6f | 20 63 65 6c 6c 20 76 61 |....>=No| cell va|
|000005b0| 6c 75 65 20 66 6f 6c 6c | 6f 77 65 64 20 4b 2d 53 |lue foll|owed K-S|
|000005c0| 59 4c 4b 20 70 61 72 6d | 20 77 68 69 6c 65 20 72 |YLK parm| while r|
|000005d0| 65 61 64 69 6e 67 20 73 | 70 72 65 61 64 73 68 65 |eading s|preadshe|
|000005e0| 65 74 2e 00 00 00 2b 2a | 55 6e 61 62 6c 65 20 74 |et....+*|Unable t|
|000005f0| 6f 20 65 76 61 6c 75 61 | 74 65 20 66 6f 72 6d 75 |o evalua|te formu|
|00000600| 6c 61 20 69 6e 20 73 70 | 72 65 61 64 73 68 65 65 |la in sp|readshee|
|00000610| 74 2e 00 00 00 33 32 42 | 6f 75 6e 64 73 20 65 72 |t....32B|ounds er|
|00000620| 72 6f 72 20 65 6e 63 6f | 75 6e 74 65 72 65 64 20 |ror enco|untered |
|00000630| 77 68 69 6c 65 20 72 65 | 61 64 69 6e 67 20 73 70 |while re|ading sp|
|00000640| 72 65 61 64 73 68 65 65 | 74 00 00 00 1f 1e 55 6e |readshee|t.....Un|
|00000650| 61 62 6c 65 20 74 6f 20 | 72 65 61 64 20 69 6e 20 |able to |read in |
|00000660| 73 70 72 65 61 64 73 68 | 65 65 74 2e 00 00 00 28 |spreadsh|eet....(|
|00000670| 27 55 6e 61 62 6c 65 20 | 74 6f 20 72 65 70 6c 61 |'Unable |to repla|
|00000680| 63 65 20 6f 6c 64 20 73 | 70 72 65 61 64 73 68 65 |ce old s|preadshe|
|00000690| 65 74 20 66 69 6c 65 2e | 00 00 00 28 27 55 6e 61 |et file.|...('Una|
|000006a0| 62 6c 65 20 74 6f 20 72 | 65 70 6c 61 63 65 20 6e |ble to r|eplace n|
|000006b0| 65 77 20 73 70 72 65 61 | 64 73 68 65 65 74 20 66 |ew sprea|dsheet f|
|000006c0| 69 6c 65 2e 00 00 00 21 | 20 55 6e 61 62 6c 65 20 |ile....!| Unable |
|000006d0| 74 6f 20 73 61 76 65 20 | 73 70 72 65 61 64 73 68 |to save |spreadsh|
|000006e0| 65 65 74 20 66 69 6c 65 | 2e 00 00 00 02 00 01 00 |eet file|........|
|000006f0| 00 00 02 00 01 00 00 00 | 02 00 01 00 00 00 02 00 |........|........|
|00000700| 01 00 00 00 02 00 01 00 | 00 00 02 00 01 00 00 00 |........|........|
|00000710| 02 00 01 00 00 00 02 00 | 01 00 00 00 02 00 01 00 |........|........|
|00000720| 00 00 02 00 01 00 00 00 | 15 00 3c 00 4c 00 aa 01 |........|..<.L...|
|00000730| a9 00 01 01 00 00 00 00 | 00 00 00 0f a0 00 00 00 |........|........|
|00000740| 00 8a 00 06 00 00 00 00 | 00 0a 01 10 00 1e 01 4c |........|.......L|
|00000750| 04 04 53 74 6f 70 00 00 | 00 00 00 2a 00 33 00 5f |..Stop..|...*.3._|
|00000760| 01 4b 80 00 00 00 00 00 | 00 48 00 3c 00 58 00 b4 |.K......|.H.<.X..|
|00000770| 88 11 43 75 72 72 65 6e | 74 20 4f 62 6a 65 63 74 |..Curren|t Object|
|00000780| 69 76 65 11 00 00 00 00 | 00 31 00 bd 00 42 00 f7 |ive.....|.1...B..|
|00000790| 88 01 30 76 00 00 00 00 | 00 0c 00 18 00 1c 00 f6 |..0v....|........|
|000007a0| 88 00 00 00 00 00 00 31 | 00 5f 00 41 00 b4 88 0b |.......1|._.A....|
|000007b0| 49 74 65 72 61 74 69 6f | 6e 20 23 5f 00 00 00 00 |Iteratio|n #_....|
|000007c0| 00 47 00 bd 00 58 01 42 | 88 01 30 20 00 00 00 8c |.G...X.B|..0 ....|
|000007d0| 00 07 00 00 00 00 00 d8 | 00 0e 00 ec 00 56 04 06 |........|.....V..|
|000007e0| 54 6f 70 69 63 73 00 00 | 00 00 00 d8 01 10 00 ec |Topics..|........|
|000007f0| 01 58 04 06 43 61 6e 63 | 65 6c 00 00 00 00 00 18 |.X..Canc|el......|
|00000800| 00 08 00 ce 01 58 00 00 | 00 00 00 00 00 d8 00 64 |.....X..|.......d|
|00000810| 00 ec 00 ac 04 04 4e 65 | 78 74 00 00 00 00 00 d8 |......Ne|xt......|
|00000820| 00 ba 00 ec 01 02 04 08 | 50 72 65 76 69 6f 75 73 |........|Previous|
|00000830| 00 00 00 00 00 04 00 0a | 00 14 01 51 80 00 00 00 |........|...Q....|
|00000840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000850| 00 1a 00 0c 00 ca 00 9e | 40 02 13 88 00 00 00 1c |........|@.......|
|00000860| 1b 44 65 74 65 72 6d 69 | 6e 69 6e 67 20 43 6f 65 |.Determi|ning Coe|
|00000870| 66 66 69 63 69 65 6e 74 | 73 2e 2e 2e 00 00 00 1c |fficient|s.......|
|00000880| 1b 43 6f 6e 64 75 63 74 | 69 6e 67 20 50 6f 73 74 |.Conduct|ing Post|
|00000890| 20 41 6e 61 6c 79 73 69 | 73 2e 2e 2e 00 00 00 33 | Analysi|s......3|
|000008a0| 32 42 6f 75 6e 64 73 20 | 65 72 72 6f 72 20 65 6e |2Bounds |error en|
|000008b0| 63 6f 75 6e 74 65 72 65 | 64 20 77 68 69 6c 65 20 |countere|d while |
|000008c0| 72 65 61 64 69 6e 67 20 | 73 70 72 65 61 64 73 68 |reading |spreadsh|
|000008d0| 65 65 74 00 00 00 02 00 | 02 00 00 00 15 00 30 00 |eet.....|......0.|
|000008e0| 63 00 73 01 9d 00 01 01 | 00 00 00 00 00 00 00 03 |c.s.....|........|
|000008f0| e8 00 00 00 00 36 00 02 | 00 00 00 00 00 25 00 f8 |.....6..|.....%..|
|00000900| 00 39 01 34 04 06 43 61 | 6e 63 65 6c 00 00 00 00 |.9.4..Ca|ncel....|
|00000910| 00 0c 00 0a 00 1c 01 38 | 88 04 5e 30 5e 31 00 00 |.......8|..^0^1..|
|00000920| 00 00 00 28 00 0b 00 38 | 00 ef 80 00 00 00 00 1d |...(...8|........|
|00000930| 1c 52 65 63 61 6c 63 75 | 6c 61 74 69 6e 67 20 53 |.Recalcu|lating S|
|00000940| 70 72 65 61 64 73 68 65 | 65 74 2e 2e 2e 00 00 00 |preadshe|et......|
|00000950| 0c 00 3e 00 50 00 c3 01 | ae 4e 1f 55 55 00 00 00 |..>.P...|.N.UU...|
|00000960| 3c 00 02 00 00 00 00 00 | 65 00 12 00 79 00 54 04 |<.......|e...y.T.|
|00000970| 06 46 69 6e 64 65 72 00 | 00 00 00 00 0e 00 4c 00 |.Finder.|......L.|
|00000980| 59 01 4e 88 04 5e 30 5e | 31 00 00 00 00 00 9e 00 |Y.N..^0^|1.......|
|00000990| f8 00 b1 01 34 88 05 49 | 44 3d 5e 32 9e 00 00 00 |....4..I|D=^2....|
|000009a0| 4a 00 03 00 00 00 00 00 | 57 00 12 00 6b 00 4a 04 |J.......|W...k.J.|
|000009b0| 02 4f 4b 00 00 00 00 00 | 57 00 5f 00 6b 00 9b 04 |.OK.....|W._.k...|
|000009c0| 04 48 65 6c 70 00 00 00 | 00 00 0e 00 4c 00 4f 01 |.Help...|....L.O.|
|000009d0| 4e 88 04 5e 30 5e 31 00 | 00 00 00 00 9e 00 f8 00 |N..^0^1.|........|
|000009e0| b1 01 34 88 05 49 44 3d | 5e 32 44 00 00 00 15 00 |..4..ID=|^2D.....|
|000009f0| 1e 00 10 00 41 01 f2 00 | 01 01 00 00 00 00 00 00 |....A...|........|
|00000a00| 00 1b 58 00 00 00 00 15 | 00 4a 00 88 00 b7 01 78 |..X.....|.J.....x|
|00000a10| 00 01 01 00 00 00 00 00 | 00 00 1f 40 00 00 00 00 |........|...@....|
|00000a20| 15 00 40 00 70 00 d2 01 | 90 00 01 01 00 00 00 00 |..@.p...|........|
|00000a30| 00 00 00 23 28 00 00 00 | 00 5c 00 04 00 00 00 00 |...#(...|.\......|
|00000a40| 00 07 01 98 00 1b 01 d4 | 04 02 4f 4b 00 00 00 00 |........|..OK....|
|00000a50| 00 07 01 4c 00 1b 01 88 | 04 06 43 61 6e 63 65 6c |...L....|..Cancel|
|00000a60| 00 00 00 00 00 0a 00 0a | 00 1a 00 29 88 05 43 65 |........|...)..Ce|
|00000a70| 6c 6c 20 61 00 00 00 00 | 00 0a 00 29 00 1a 00 5a |ll a....|...)...Z|
|00000a80| 88 05 61 61 31 31 31 08 | 00 00 00 00 00 0a 00 5e |..aa111.|.......^|
|00000a90| 00 1a 01 3e 90 00 00 00 | 00 b4 00 06 00 00 00 00 |...>....|........|
|00000aa0| 00 0b 00 08 00 1b 00 f0 | 88 1c 5f 5f 5f 5f 5f 5f |........|..______|
|00000ab0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000ac0| 5f 5f 5f 5f 5f 5f 00 00 | 00 00 00 20 00 00 00 30 |______..|... ...0|
|00000ad0| 00 78 88 05 43 65 6c 6c | 3a 5f 00 00 00 00 00 30 |.x..Cell|:_.....0|
|00000ae0| 00 00 00 40 00 78 88 0d | 53 68 61 64 6f 77 20 50 |...@.x..|Shadow P|
|00000af0| 72 69 63 65 3a 00 00 00 | 00 00 00 20 00 78 00 30 |rice:...|... .x.0|
|00000b00| 00 b0 88 05 61 61 31 31 | 31 77 00 00 00 00 00 30 |....aa11|1w.....0|
|00000b10| 00 78 00 40 00 ed 88 0b | 31 32 33 34 35 36 37 38 |.x.@....|12345678|
|00000b20| 39 30 31 31 00 00 00 00 | 00 50 00 58 00 64 00 94 |9011....|.P.X.d..|
|00000b30| 04 02 4f 4b 00 00 00 00 | 00 02 00 45 00 14 00 a7 |..OK....|...E....|
|00000b40| 88 0c 53 68 61 64 6f 77 | 20 50 72 69 63 65 00 00 |..Shadow| Price..|
|00000b50| 01 48 00 0a 00 00 00 00 | 00 70 00 71 00 84 00 ad |.H......|.p.q....|
|00000b60| 04 02 4f 4b 00 00 00 00 | 00 0a 00 07 00 18 01 1b |..OK....|........|
|00000b70| 88 24 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |.$______|________|
|00000b80| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000b90| 5f 5f 5f 5f 5f 5f 00 00 | 00 00 00 20 00 08 00 30 |______..|... ...0|
|00000ba0| 00 78 88 10 41 64 6a 75 | 73 74 61 62 6c 65 20 43 |.x..Adju|stable C|
|00000bb0| 65 6c 6c 3a 00 00 00 00 | 00 20 00 a8 00 30 00 e8 |ell:....|. ...0..|
|00000bc0| 88 05 41 31 31 31 31 43 | 00 00 00 00 00 40 00 08 |..A1111C|.....@..|
|00000bd0| 00 50 00 a8 88 14 41 63 | 74 75 61 6c 20 43 6f 6e |.P....Ac|tual Con|
|00000be0| 74 72 69 62 75 74 69 6f | 6e 3a 00 00 00 00 00 30 |tributio|n:.....0|
|00000bf0| 00 08 00 40 00 a8 88 15 | 4d 69 6e 69 6d 75 6d 20 |...@....|Minimum |
|00000c00| 43 6f 6e 74 72 69 62 75 | 74 69 6f 6e 3a a8 00 00 |Contribu|tion:...|
|00000c10| 00 00 00 50 00 08 00 60 | 00 a8 88 15 4d 61 78 69 |...P...`|....Maxi|
|00000c20| 6d 75 6d 20 43 6f 6e 74 | 72 69 62 75 74 69 6f 6e |mum Cont|ribution|
|00000c30| 3a a8 00 00 00 00 00 30 | 00 a8 00 40 01 1c 88 09 |:......0|...@....|
|00000c40| 31 32 33 34 35 36 37 38 | 39 40 00 00 00 00 00 40 |12345678|9@.....@|
|00000c50| 00 a8 00 50 01 1c 88 09 | 31 32 33 34 35 36 37 38 |...P....|12345678|
|00000c60| 39 30 00 00 00 00 00 50 | 00 a8 00 60 01 1c 88 09 |90.....P|...`....|
|00000c70| 31 32 33 34 35 36 37 38 | 39 50 00 00 00 00 00 01 |12345678|9P......|
|00000c80| 00 48 00 13 00 d0 88 12 | 43 6f 6e 74 72 69 62 75 |.H......|Contribu|
|00000c90| 74 69 6f 6e 20 52 61 6e | 67 65 00 00 00 64 03 eb |tion Ran|ge...d..|
|00000ca0| 00 00 00 00 00 00 00 00 | ff ff ff f7 0c 4f 70 74 |........|.....Opt|
|00000cb0| 69 6d 69 7a 61 74 69 6f | 6e 08 4d 61 78 69 6d 69 |imizatio|n.Maximi|
|00000cc0| 7a 65 00 4d 00 00 08 4d | 69 6e 69 6d 69 7a 65 00 |ze.M...M|inimize.|
|00000cd0| 4e 00 00 01 2d 00 00 00 | 00 12 43 6f 6e 74 72 69 |N...-...|..Contri|
|00000ce0| 62 75 74 69 6f 6e 20 52 | 61 6e 67 65 00 54 00 00 |bution R|ange.T..|
|00000cf0| 0c 53 68 61 64 6f 77 20 | 50 72 69 63 65 00 59 00 |.Shadow |Price.Y.|
|00000d00| 00 00 00 00 00 1e 1d 54 | 6f 6f 20 6d 61 6e 79 20 |.......T|oo many |
|00000d10| 63 65 6c 6c 73 20 77 65 | 72 65 20 73 65 6c 65 63 |cells we|re selec|
|00000d20| 74 65 64 2e 00 00 00 02 | 00 03 00 00 00 31 03 e8 |ted.....|.....1..|
|00000d30| 00 00 00 00 00 00 00 00 | ff ff ff fb 01 14 15 41 |........|.......A|
|00000d40| 62 6f 75 74 20 42 65 73 | 74 20 41 6e 73 77 65 72 |bout Bes|t Answer|
|00000d50| aa 2e 2e 2e 00 00 00 00 | 01 2d 00 00 00 00 00 00 |........|.-......|
|00000d60| 00 00 27 00 3e 00 44 01 | 36 01 b6 00 00 01 00 00 |..'.>.D.|6.......|
|00000d70| 00 00 00 00 00 13 88 12 | 41 62 6f 75 74 20 42 65 |........|About Be|
|00000d80| 73 74 20 41 6e 73 77 65 | 72 aa 00 00 00 56 55 0d |st Answe|r....VU.|
|00000d90| 0d 0d 54 68 65 20 22 48 | 65 6c 70 22 20 66 65 61 |..The "H|elp" fea|
|00000da0| 74 75 72 65 20 69 73 20 | 6f 6e 6c 79 20 61 76 61 |ture is |only ava|
|00000db0| 69 6c 61 62 6c 65 20 77 | 69 74 68 20 76 65 72 73 |ilable w|ith vers|
|00000dc0| 69 6f 6e 20 33 2e 32 20 | 6f 72 20 6c 61 74 65 72 |ion 3.2 |or later|
|00000dd0| 20 6f 66 20 74 68 65 20 | 73 79 73 74 65 6d 20 66 | of the |system f|
|00000de0| 69 6c 65 2e 00 00 00 0c | 00 44 00 36 00 bc 01 24 |ile.....|.D.6...$|
|00000df0| 3a 98 55 55 00 00 00 54 | 00 02 00 00 00 00 00 3a |:.UU...T|.......:|
|00000e00| 00 19 00 4c 00 63 04 02 | 4f 4b 00 00 00 00 00 3a |...L.c..|OK.....:|
|00000e10| 00 8c 00 4c 00 d6 04 06 | 43 61 6e 63 65 6c 00 00 |...L....|Cancel..|
|00000e20| 00 00 00 0c 00 14 00 2d | 00 df 88 20 52 65 76 65 |.......-|... Reve|
|00000e30| 72 74 20 74 6f 20 73 61 | 76 65 64 20 76 65 72 73 |rt to sa|ved vers|
|00000e40| 69 6f 6e 20 6f 66 20 22 | 5e 30 22 3f 00 00 00 0c |ion of "|^0"?....|
|00000e50| 00 3c 00 32 00 92 01 20 | 36 b0 44 44 00 00 00 5e |.<.2... |6.DD...^|
|00000e60| 00 03 00 00 00 00 00 3a | 00 19 00 4c 00 63 04 03 |.......:|...L.c..|
|00000e70| 59 65 73 6e 00 00 00 00 | 00 56 00 8d 00 68 00 d7 |Yesn....|.V...h..|
|00000e80| 04 06 43 61 6e 63 65 6c | 00 00 00 00 00 56 00 19 |..Cancel|.....V..|
|00000e90| 00 68 00 63 04 03 20 4e | 6f 4e 00 00 00 00 00 0c |.h.c.. N|oN......|
|00000ea0| 00 14 00 2d 00 df 88 15 | 53 61 76 65 20 63 68 61 |...-....|Save cha|
|00000eb0| 6e 67 65 73 20 74 6f 20 | 22 5e 30 22 3f 27 00 00 |nges to |"^0"?'..|
|00000ec0| 00 59 03 e9 00 00 00 00 | 00 00 00 00 ff ff ff bf |.Y......|........|
|00000ed0| 04 46 69 6c 65 04 4f 70 | 65 6e 00 4f 00 00 05 43 |.File.Op|en.O...C|
|00000ee0| 6c 6f 73 65 00 2e 00 00 | 04 53 61 76 65 00 53 00 |lose....|.Save.S.|
|00000ef0| 00 0a 53 61 76 65 20 41 | 73 2e 2e 2e 00 00 00 00 |..Save A|s.......|
|00000f00| 06 52 65 76 65 72 74 00 | 52 00 00 01 2d 00 00 00 |.Revert.|R...-...|
|00000f10| 00 04 51 75 69 74 00 51 | 00 00 00 00 00 00 15 00 |..Quit.Q|........|
|00000f20| 1e 00 10 00 56 01 f2 00 | 01 00 00 00 00 00 00 00 |....V...|........|
|00000f30| 00 27 10 00 00 00 00 58 | 00 04 00 00 00 00 00 05 |.'.....X|........|
|00000f40| 01 99 00 19 01 d5 04 02 | 4f 4b 00 00 00 00 00 0a |........|OK......|
|00000f50| 00 0a 00 1a 00 29 88 05 | 43 65 6c 6c 20 6c 00 00 |.....)..|Cell l..|
|00000f60| 00 00 00 0a 00 29 00 1a | 00 5a 88 02 5e 30 00 00 |.....)..|.Z..^0..|
|00000f70| 00 00 00 22 00 08 00 32 | 01 d6 88 04 5e 32 5e 33 |..."...2|....^2^3|
|00000f80| 00 00 00 00 00 0a 00 5b | 00 1a 01 3b 88 02 5e 31 |.......[|...;..^1|
|00000f90| 00 00 00 14 13 4e 6f 74 | 20 61 20 66 6f 72 6d 75 |.....Not| a formu|
|00000fa0| 6c 61 20 63 65 6c 6c 2e | 00 00 00 02 00 00 00 00 |la cell.|........|
|00000fb0| 00 c4 03 ea 00 00 00 00 | 00 00 00 00 ff ff fd ef |........|........|
|00000fc0| 04 43 65 6c 6c 12 44 65 | 66 69 6e 65 20 41 64 6a |.Cell.De|fine Adj|
|00000fd0| 75 73 74 61 62 6c 65 73 | 00 41 00 00 12 44 65 66 |ustables|.A...Def|
|00000fe0| 69 6e 65 20 43 6f 6e 73 | 74 72 61 69 6e 74 73 00 |ine Cons|traints.|
|00000ff0| 4b 00 00 10 44 65 66 69 | 6e 65 20 4f 62 6a 65 63 |K...Defi|ne Objec|
|00001000| 74 69 76 65 00 42 00 00 | 01 2d 00 00 00 00 10 53 |tive.B..|.-.....S|
|00001010| 68 6f 77 20 41 64 6a 75 | 73 74 61 62 6c 65 73 00 |how Adju|stables.|
|00001020| 00 00 00 10 53 68 6f 77 | 20 43 6f 6e 73 74 72 61 |....Show| Constra|
|00001030| 69 6e 74 73 00 00 00 00 | 0e 53 68 6f 77 20 4f 62 |ints....|.Show Ob|
|00001040| 6a 65 63 74 69 76 65 00 | 00 00 00 12 53 68 6f 77 |jective.|....Show|
|00001050| 20 43 65 6c 6c 20 43 6f | 6e 74 65 6e 74 73 00 46 | Cell Co|ntents.F|
|00001060| 00 00 01 2d 00 00 00 00 | 08 47 6f 20 54 6f 2e 2e |...-....|.Go To..|
|00001070| 2e 00 47 00 00 00 00 00 | 09 8b 09 8b 00 8e 00 6a |..G.....|.......j|
|00001080| 01 3e 00 fc 11 01 01 00 | 0a 00 8e 00 6a 01 3e 00 |.>......|....j.>.|
|00001090| fc 98 00 14 00 8e 00 68 | 00 b6 01 00 00 8e 00 6a |.......h|.......j|
|000010a0| 00 b6 00 fc 00 8e 00 6a | 00 b6 00 fc 00 00 08 fc |.......j|........|
|000010b0| 00 f9 11 00 10 fb 00 08 | fc 00 f9 11 00 10 fb 00 |........|........|
|000010c0| 08 fc 00 f9 11 00 10 fb | 00 08 fc 00 f9 11 00 10 |........|........|
|000010d0| fb 00 08 fc 00 f9 11 00 | 10 fb 00 08 fc 00 f9 11 |........|........|
|000010e0| 00 10 fb 00 0c fc 00 02 | 11 11 99 fc 11 00 10 fb |........|........|
|000010f0| 00 0d fc 00 03 11 19 99 | 91 fd 11 00 10 fb 00 0c |........|........|
|00001100| fc 00 00 11 fe 99 fd 11 | 00 10 fb 00 0c fc 00 00 |........|........|
|00001110| 19 fe 99 fd 11 00 10 fb | 00 0e fc 00 00 19 fe 99 |........|........|
|00001120| 00 91 fe 11 00 10 fb 00 | 0e fc 00 00 19 fe 99 00 |........|........|
|00001130| 91 fe 11 00 10 fb 00 0c | fc 00 00 19 fd 99 fe 11 |........|........|
|00001140| 00 10 fb 00 0c fc 00 00 | 19 fd 99 fe 11 00 10 fb |........|........|
|00001150| 00 0c fc 00 00 19 fd 99 | fe 11 00 10 fb 00 0c fc |........|........|
|00001160| 00 00 19 fd 99 fe 11 00 | 10 fb 00 0d fc 00 00 19 |........|........|
|00001170| fd 99 03 91 11 11 10 fb | 00 0d fc 00 00 19 fd 99 |........|........|
|00001180| 03 91 11 11 10 fb 00 0d | fc 00 00 19 fd 99 03 91 |........|........|
|00001190| 11 11 10 fb 00 0d fc 00 | 00 19 fd 99 03 91 11 11 |........|........|
|000011a0| 10 fb 00 0d fc 00 00 19 | fd 99 03 91 11 11 10 fb |........|........|
|000011b0| 00 0d fc 00 00 19 fd 99 | 03 91 11 11 10 fb 00 0c |........|........|
|000011c0| fc 00 00 19 fc 99 02 11 | 11 10 fb 00 0c fc 00 00 |........|........|
|000011d0| 19 fc 99 02 11 11 10 fb | 00 0c fc 00 00 19 fc 99 |........|........|
|000011e0| 02 11 11 10 fb 00 0c fc | 00 00 19 fc 99 02 11 11 |........|........|
|000011f0| 10 fb 00 0c fc 00 00 19 | fc 99 02 11 11 10 fb 00 |........|........|
|00001200| 0c fc 00 00 19 fc 99 02 | 11 11 10 fb 00 0c fc 00 |........|........|
|00001210| 00 19 fc 99 02 11 11 10 | fb 00 0c fc 00 00 19 fc |........|........|
|00001220| 99 02 11 11 10 fb 00 0c | fc 00 00 19 fc 99 02 11 |........|........|
|00001230| 11 10 fb 00 0c fc 00 00 | 19 fc 99 02 11 11 10 fb |........|........|
|00001240| 00 0c fc 00 00 19 fc 99 | 02 11 11 10 fb 00 0c fc |........|........|
|00001250| 00 00 19 fc 99 02 11 11 | 10 fb 00 0c fc 00 00 19 |........|........|
|00001260| fc 99 02 11 11 10 fb 00 | 0c fc 00 00 19 fc 99 02 |........|........|
|00001270| 11 11 10 fb 00 0c fc 00 | 00 19 fc 99 02 11 11 10 |........|........|
|00001280| fb 00 0c fc 00 00 19 fc | 99 02 11 11 10 fb 00 0c |........|........|
|00001290| fc 00 00 19 fc 99 02 11 | 11 10 fb 00 0c fc 00 00 |........|........|
|000012a0| 19 fc 99 02 11 11 10 fb | 00 98 00 14 00 b6 00 68 |........|.......h|
|000012b0| 00 de 01 00 00 b6 00 6a | 00 de 00 fc 00 b6 00 6a |.......j|.......j|
|000012c0| 00 de 00 fc 00 00 0c fc | 00 00 19 fc 99 02 11 11 |........|........|
|000012d0| 10 fb 00 0c fc 00 00 19 | fc 99 02 11 11 10 fb 00 |........|........|
|000012e0| 0c fc 00 00 19 fc 99 02 | 11 11 10 fb 00 0c fc 00 |........|........|
|000012f0| 00 19 fc 99 02 11 11 10 | fb 00 0c fc 00 00 19 fc |........|........|
|00001300| 99 02 11 11 10 fb 00 0c | fc 00 00 19 fc 99 02 11 |........|........|
|00001310| 11 10 fb 00 0c fc 00 00 | 19 fc 99 02 11 11 10 fb |........|........|
|00001320| 00 0c fc 00 00 1d fc 99 | 02 11 11 10 fb 00 0c fc |........|........|
|00001330| 00 00 1d fc 99 02 11 11 | 10 fb 00 0d fc 00 01 1d |........|........|
|00001340| d9 fd 99 02 11 11 10 fb | 00 0e fc 00 01 1d d9 fe |........|........|
|00001350| 99 03 91 11 11 10 fb 00 | 0e fc 00 01 1d dd fe 99 |........|........|
|00001360| 03 d1 11 11 10 fb 00 0e | fc 00 01 1d dd fe 99 03 |........|........|
|00001370| d1 11 11 10 fb 00 0e fc | 00 08 1d dd d9 99 9d d1 |........|........|
|00001380| 11 11 10 fb 00 0e fc 00 | 08 1d dd dd 99 dd d1 11 |........|........|
|00001390| 11 10 fb 00 0d fc 00 00 | 1d fd dd 03 91 11 11 10 |........|........|
|000013a0| fb 00 0c fc 00 00 1d fd | dd fe 11 00 10 fb 00 0c |........|........|
|000013b0| fc 00 00 1d fd dd fe 11 | 00 10 fb 00 0c fc 00 00 |........|........|
|000013c0| 1d fd dd fe 11 00 10 fb | 00 0c fc 00 00 1d fd dd |........|........|
|000013d0| fe 11 00 10 fb 00 0e fc | 00 00 1d fe dd 00 d1 fe |........|........|
|000013e0| 11 00 10 fb 00 0e fc 00 | 00 1d fe dd 00 d1 fe 11 |........|........|
|000013f0| 00 10 fb 00 0e 00 c0 fd | 00 00 11 fe dd fd 11 00 |........|........|
|00001400| 10 fb 00 0e 00 c0 fd 00 | 00 11 fe dd fd 11 00 10 |........|........|
|00001410| fb 00 0f 00 c0 fd 00 03 | 11 1d dd d1 fd 11 00 10 |........|........|
|00001420| fb 00 0e 00 c0 fd 00 02 | 11 11 dd fc 11 00 10 fb |........|........|
|00001430| 00 0a 00 c0 fd 00 f9 11 | 00 10 fb 00 0a 00 c0 fd |........|........|
|00001440| 00 f9 11 00 10 fb 00 0a | 00 c0 fd 00 f9 11 00 10 |........|........|
|00001450| fb 00 0a 00 c0 fd 00 f9 | 11 00 10 fb 00 0a 00 40 |........|.......@|
|00001460| fd 00 f9 11 00 10 fb 00 | 02 ed 00 02 ed 00 02 ed |........|........|
|00001470| 00 02 ed 00 02 ed 00 02 | ed 00 02 ed 00 12 02 00 |........|........|
|00001480| 00 1f fc 00 04 01 80 00 | 18 c0 fe 00 00 38 fe 00 |........|.....8..|
|00001490| 12 03 00 00 19 80 fd 00 | 03 01 80 00 18 fd 00 00 |........|........|
|000014a0| 60 fe 00 98 00 14 00 de | 00 68 01 06 01 00 00 de |`.......|.h......|
|000014b0| 00 6a 01 06 00 fc 00 de | 00 6a 01 06 00 fc 00 00 |.j......|.j......|
|000014c0| 14 10 00 00 19 8f 1f f0 | f1 f0 e3 cd 9e 3c c7 8f |........|.....<..|
|000014d0| 80 78 f0 fe 00 12 02 00 | 00 19 fc 99 08 91 8e 23 |.x......|.......#|
|000014e0| 18 cc cc c0 cc 60 fe 00 | 12 02 00 00 19 fc 99 08 |.....`..|........|
|000014f0| c1 8c 1f 18 cc cc c0 cc | 60 fe 00 14 03 00 00 19 |........|`.......|
|00001500| 9f fe 99 09 98 e1 8c 33 | 18 cc cc c0 cc 60 fe 00 |.......3|.....`..|
|00001510| 14 10 00 00 19 98 19 99 | 99 98 71 8c 33 18 cc cc |........|..q.3...|
|00001520| c0 cc 60 fe 00 13 03 00 | 00 19 98 fd 99 08 31 8c |..`.....|......1.|
|00001530| 33 18 cc cc c0 cc 60 fe | 00 14 10 00 00 1f 0f 19 |3.....`.|........|
|00001540| 98 f1 98 e0 cc 1f 0c c7 | 8c c0 78 60 fe 00 02 ed |........|..x`....|
|00001550| 00 04 00 80 ee 00 04 00 | c0 ee 00 04 00 c0 ee 00 |........|........|
|00001560| 04 00 c0 ee 00 04 00 c0 | ee 00 13 05 df 00 00 18 |........|........|
|00001570| 07 80 fd 00 01 07 44 fd | 00 03 18 01 e0 00 13 05 |......D.|........|
|00001580| d9 80 00 18 0c c0 fd 00 | 01 02 6c fd 00 03 38 03 |........|..l...8.|
|00001590| 30 00 15 13 19 8f 0e 3c | 0c cf 87 19 98 f1 b2 54 |0......<|.......T|
|000015a0| 00 cc 78 d8 18 03 30 00 | 15 06 19 99 99 18 0c cc |..x...0.|........|
|000015b0| cc fe 99 09 c2 44 00 cc | cc e0 18 03 30 00 15 13 |.....D..|....0...|
|000015c0| 1f 19 9c 18 0f cc ce 19 | 99 99 80 00 00 cc cc c0 |........|........|
|000015d0| 18 03 30 00 15 13 19 9f | 8e 18 0c cc c7 19 99 f9 |..0.....|........|
|000015e0| 80 00 00 cc fc c0 18 03 | 30 00 15 13 19 98 07 18 |........|0.......|
|000015f0| 0c cc c3 99 99 81 80 00 | 00 cc c0 c0 18 03 30 00 |........|......0.|
|00001600| 15 13 19 98 93 18 0c cc | c9 99 91 89 80 00 00 c8 |........|........|
|00001610| c4 c0 18 63 30 00 15 13 | 1f 0f 0e 0c 0c cc c7 1f |...c0...|........|
|00001620| e0 f1 80 00 00 f0 78 c0 | 18 61 e0 00 02 ed 00 04 |......x.|.a......|
|00001630| 00 80 ee 00 04 00 c0 ee | 00 04 00 80 ee 00 04 00 |........|........|
|00001640| 80 ee 00 07 00 9f f0 ff | 01 f0 00 04 00 80 ee 00 |........|........|
|00001650| 04 00 80 ee 00 02 ed 00 | 02 ed 00 02 ed 00 12 0a |........|........|
|00001660| 00 10 08 00 06 00 03 01 | f0 00 03 fd 00 00 c0 fd |........|........|
|00001670| 00 0c 08 00 18 18 00 06 | 00 03 01 80 f6 00 15 11 |........|........|
|00001680| 00 1c 38 f1 b6 63 c7 81 | 83 e1 f3 3e 1e 1e 36 cf |..8..c..|...>..6.|
|00001690| 87 c0 ff 00 13 08 00 1e | 79 19 c6 c6 63 01 83 fc |........|y...c...|
|000016a0| 33 03 38 cc cc c0 ff 00 | 13 08 00 17 d8 f9 87 86 |3.8.....|........|
|000016b0| 63 01 e3 fc 33 03 30 cc | cc c0 ff 00 15 08 00 13 |c...3.0.|........|
|000016c0| 99 99 87 07 e3 01 83 fe | 33 05 3f 3f 30 cc cc c0 |........|3.??0...|
|000016d0| ff 00 14 08 00 11 19 99 | 87 86 03 01 83 fe 33 fe |........|......3.|
|000016e0| 30 02 cc cc c0 ff 00 98 | 00 14 01 06 00 68 01 2e |0.......|.....h..|
|000016f0| 01 00 01 06 00 6a 01 2e | 00 fc 01 06 00 6a 01 2e |.....j..|.....j..|
|00001700| 00 fc 00 00 15 08 00 10 | 19 99 86 c6 23 01 83 fe |........|....#...|
|00001710| 33 05 31 31 30 cc cc c0 | ff 00 15 11 00 10 18 f9 |3.110...|........|
|00001720| 86 63 c1 81 f3 31 f3 33 | 1e 1e 30 cc c7 c0 ff 00 |.c...1.3|..0.....|
|00001730| 0a f7 00 00 30 fb 00 00 | c0 ff 00 0c f8 00 01 02 |....0...|........|
|00001740| 30 fc 00 01 08 c0 ff 00 | 0c f8 00 01 01 e0 fc 00 |0.......|........|
|00001750| 01 07 80 ff 00 02 ed 00 | 02 ed 00 02 ed 00 13 01 |........|........|
|00001760| 00 1e fc 00 01 01 8c fe | 00 05 f0 03 07 87 8f c0 |........|........|
|00001770| ff 00 13 01 00 31 fc 00 | 0a 01 80 00 00 01 08 07 |.....1..|........|
|00001780| 0c cc c0 c0 ff 00 15 11 | 00 30 1e 36 f8 78 d9 e3 |........|.0.6.x..|
|00001790| cc 78 f8 02 64 03 0c cc | c0 c0 ff 00 15 11 00 30 |.x..d...|.......0|
|000017a0| 33 38 cc cc e2 31 8c cc | cc 02 94 03 0c cc c0 c0 |38...1..|........|
|000017b0| ff 00 15 11 00 30 33 30 | cc cc c1 f1 8c cc cc 02 |.....030|........|
|000017c0| 84 03 0c c7 81 80 ff 00 | 14 10 00 30 33 30 cc cc |........|...030..|
|000017d0| c3 31 8c cc cc 02 94 03 | 07 cc c3 fe 00 14 10 00 |.1......|........|
|000017e0| 30 33 30 cc cc c3 31 8c | cc cc 02 64 03 00 cc c3 |030...1.|...d....|
|000017f0| fe 00 14 10 00 31 33 30 | cc cc c3 31 8c cc cc 01 |.....130|...1....|
|00001800| 08 03 01 8c c3 fe 00 14 | 10 00 1e 1e 30 f8 78 c1 |........|....0.x.|
|00001810| f0 cc 78 cc 00 f0 03 07 | 07 83 fe 00 06 fd 00 00 |..x.....|........|
|00001820| c0 f2 00 06 fd 00 00 c0 | f2 00 02 ed 00 02 ed 00 |........|........|
|00001830| 02 ed 00 02 ed 00 07 00 | 3f f0 ff 01 e0 00 02 ed |........|?.......|
|00001840| 00 02 ed 00 02 ed 00 02 | ed 00 0e 0a 00 07 c0 00 |........|........|
|00001850| 7c 03 00 06 66 00 60 f8 | 00 0c 08 00 06 60 00 60 ||...f.`.|.....`.`|
|00001860| 00 00 06 66 f6 00 14 10 | 00 06 66 60 60 db 1c 06 |...f....|..f``...|
|00001870| 66 3c 63 87 1f f0 f1 f1 | f0 fe 00 14 07 00 06 66 |f<c.....|.......f|
|00001880| 60 60 e3 32 06 fe 66 05 | 4c 99 99 19 99 98 fe 00 |``.2..f.|L.......|
|00001890| 14 10 00 07 c6 60 78 c3 | 30 06 66 66 67 0e 19 98 |.....`x.|0.ffg...|
|000018a0| f9 99 98 fe 00 14 0c 00 | 06 66 60 60 c3 30 06 66 |........|.f``.0.f|
|000018b0| 7e 63 87 19 fe 99 00 98 | fe 00 13 0b 00 06 66 60 |~c......|......f`|
|000018c0| 60 c3 30 06 66 60 61 c3 | fd 99 00 98 fe 00 13 0b |`.0.f`a.|........|
|000018d0| 00 06 66 60 60 c3 32 06 | 64 62 64 c9 fd 99 00 98 |..f``.2.|dbd.....|
|000018e0| fe 00 14 10 00 07 c3 e0 | 7c c3 1c 07 f8 3c 63 87 |........||....<c.|
|000018f0| 19 98 f9 99 98 fe 00 06 | fe 00 00 60 f1 00 07 03 |........|...`....|
|00001900| 00 00 04 60 f1 00 07 03 | 00 00 03 c0 f1 00 98 00 |...`....|........|
|00001910| 14 01 2e 00 68 01 3e 01 | 00 01 2e 00 6a 01 3e 00 |....h.>.|....j.>.|
|00001920| fc 01 2e 00 6a 01 3e 00 | fc 00 00 02 ed 00 02 ed |....j.>.|........|
|00001930| 00 02 ed 00 02 ed 00 14 | 10 00 03 c0 00 7c 03 00 |........|.....|..|
|00001940| 06 66 00 60 00 00 01 80 | 18 0c fe 00 11 08 00 06 |.f.`....|........|
|00001950| 60 00 60 00 00 06 66 fb | 00 01 18 0c fe 00 14 10 |`.`...f.|........|
|00001960| 00 06 68 00 60 db 1c 06 | 66 3c 67 c6 66 6d 8f 9f |..h.`...|f<g.fm..|
|00001970| 1e fe 00 14 09 00 03 08 | 00 60 e3 32 06 66 46 fe |........|.`.2.fF.|
|00001980| 66 03 71 99 99 8c fe 00 | 14 09 00 06 70 00 78 c3 |f.q.....|....p.x.|
|00001990| 30 06 66 3e fe 66 03 61 | 99 99 8c fe 00 12 07 00 |0.f>.f.a|........|
|000019a0| 06 60 00 60 c3 30 06 fc | 66 03 61 99 99 8c fe 00 |.`.`.0..|f.a.....|
|000019b0| 12 07 00 06 60 00 60 c3 | 30 06 fc 66 03 61 99 99 |....`.`.|0..f.a..|
|000019c0| 8c fe 00 14 08 00 06 60 | 00 60 c3 32 06 64 fe 66 |.......`|.`.2.d.f|
|000019d0| 04 64 61 99 99 8c fe 00 | 14 10 00 03 c0 00 7c c3 |.da.....|......|.|
|000019e0| 1c 07 f8 3e 66 67 f8 61 | 8f 99 86 fe 00 07 f3 00 |...>fg.a|........|
|000019f0| 01 01 80 fd 00 07 f3 00 | 01 11 80 fd 00 06 f3 00 |........|........|
|00001a00| 00 0f fc 00 ff 00 00 00 | 17 16 55 6e 6b 6e 6f 77 |........|..Unknow|
|00001a10| 6e 20 65 72 72 6f 72 20 | 6d 65 73 73 61 67 65 2e |n error |message.|
|00001a20| 00 00 00 44 43 20 20 54 | 68 69 73 20 69 73 20 61 |...DC  T|his is a|
|00001a30| 20 46 61 74 61 6c 20 45 | 72 72 6f 72 20 2d 2d 20 | Fatal E|rror -- |
|00001a40| 43 61 6c 6c 20 4d 61 72 | 6b 65 74 20 45 6e 67 69 |Call Mar|ket Engi|
|00001a50| 6e 65 65 72 69 6e 67 2c | 20 31 2d 33 30 33 2d 38 |neering,| 1-303-8|
|00001a60| 39 33 2d 30 31 30 30 2e | 00 00 00 2c 2b 55 6e 61 |93-0100.|...,+Una|
|00001a70| 62 6c 65 20 74 6f 20 64 | 69 73 70 6f 73 65 20 6f |ble to d|ispose o|
|00001a80| 66 20 73 70 72 65 61 64 | 73 68 65 65 74 20 69 6e |f spread|sheet in|
|00001a90| 20 6d 65 6d 6f 72 79 2e | 00 00 00 37 36 4e 6f 74 | memory.|...76Not|
|00001aa0| 20 65 6e 6f 75 67 68 20 | 6d 65 6d 6f 72 79 20 61 | enough |memory a|
|00001ab0| 76 61 69 6c 61 62 6c 65 | 20 74 6f 20 63 6f 6d 70 |vailable| to comp|
|00001ac0| 6c 65 74 65 20 74 68 65 | 20 6f 70 65 72 61 74 69 |lete the| operati|
|00001ad0| 6f 6e 2e 00 00 00 1f 1e | 54 6f 6f 20 6d 61 6e 79 |on......|Too many|
|00001ae0| 20 73 65 6c 65 63 74 69 | 6f 6e 73 20 77 65 72 65 | selecti|ons were|
|00001af0| 20 6d 61 64 65 2e 00 00 | 00 33 32 41 64 6a 75 73 | made...|.32Adjus|
|00001b00| 74 61 62 6c 65 20 63 65 | 6c 6c 73 20 6d 75 73 74 |table ce|lls must|
|00001b10| 20 6f 6e 6c 79 20 63 6f | 6e 74 61 69 6e 20 6e 75 | only co|ntain nu|
|00001b20| 6d 65 72 69 63 20 76 61 | 6c 75 65 73 2e 00 00 00 |meric va|lues....|
|00001b30| 2d 2c 43 6f 6e 73 74 72 | 61 69 6e 74 20 63 65 6c |-,Constr|aint cel|
|00001b40| 6c 73 20 6d 75 73 74 20 | 6f 6e 6c 79 20 63 6f 6e |ls must |only con|
|00001b50| 74 61 69 6e 20 66 6f 72 | 6d 75 6c 61 73 2e 00 00 |tain for|mulas...|
|00001b60| 00 30 2f 54 68 65 20 6f | 62 6a 65 63 74 69 76 65 |.0/The o|bjective|
|00001b70| 20 63 65 6c 6c 20 6d 75 | 73 74 20 6f 6e 6c 79 20 | cell mu|st only |
|00001b80| 63 6f 6e 74 61 69 6e 20 | 61 20 66 6f 72 6d 75 6c |contain |a formul|
|00001b90| 61 2e 00 00 00 35 34 54 | 68 65 20 63 65 6c 6c 20 |a....54T|he cell |
|00001ba0| 79 6f 75 20 77 69 73 68 | 20 74 6f 20 6c 6f 63 61 |you wish| to loca|
|00001bb0| 74 65 20 69 73 20 6e 6f | 74 20 6f 6e 20 74 68 65 |te is no|t on the|
|00001bc0| 20 77 6f 72 6b 73 68 65 | 65 74 2e 00 00 00 34 33 | workshe|et....43|
|00001bd0| 54 68 65 20 63 65 6c 6c | 20 79 6f 75 20 77 69 73 |The cell| you wis|
|00001be0| 68 20 74 6f 20 6c 6f 63 | 61 74 65 20 6d 75 73 74 |h to loc|ate must|
|00001bf0| 20 62 65 20 69 6e 20 22 | 41 31 22 20 66 6f 72 6d | be in "|A1" form|
|00001c00| 61 74 2e 00 00 00 14 13 | 4e 6f 74 20 61 20 76 61 |at......|Not a va|
|00001c10| 6c 69 64 20 6e 75 6d 62 | 65 72 2e 00 00 00 23 22 |lid numb|er....#"|
|00001c20| 4f 6e 6c 79 20 6e 75 6d | 65 72 69 63 20 63 65 6c |Only num|eric cel|
|00001c30| 6c 73 20 6d 61 79 20 62 | 65 20 63 68 61 6e 67 65 |ls may b|e change|
|00001c40| 64 2e 00 00 00 3d 3c 43 | 6f 6e 74 72 69 62 75 74 |d....=<C|ontribut|
|00001c50| 69 6f 6e 20 72 61 6e 67 | 65 73 20 61 72 65 20 6f |ion rang|es are o|
|00001c60| 6e 6c 79 20 61 76 61 69 | 6c 61 62 6c 65 20 66 6f |nly avai|lable fo|
|00001c70| 72 20 61 64 6a 75 73 74 | 61 62 6c 65 20 63 65 6c |r adjust|able cel|
|00001c80| 6c 73 2e 00 00 00 37 36 | 53 68 61 64 6f 77 20 70 |ls....76|Shadow p|
|00001c90| 72 69 63 65 73 20 61 72 | 65 20 6f 6e 6c 79 20 61 |rices ar|e only a|
|00001ca0| 76 61 69 6c 61 62 6c 65 | 20 66 6f 72 20 63 6f 6e |vailable| for con|
|00001cb0| 73 74 72 61 69 6e 74 20 | 63 65 6c 6c 73 2e 00 00 |straint |cells...|
|00001cc0| 00 52 51 54 6f 6f 20 6d | 61 6e 79 20 61 64 6a 75 |.RQToo m|any adju|
|00001cd0| 73 74 61 62 6c 65 20 63 | 65 6c 6c 73 20 77 65 72 |stable c|ells wer|
|00001ce0| 65 20 73 65 6c 65 63 74 | 65 64 2e 20 20 4c 69 6d |e select|ed.  Lim|
|00001cf0| 69 74 65 64 20 74 6f 20 | 35 20 63 65 6c 6c 73 20 |ited to |5 cells |
|00001d00| 69 6e 20 74 68 65 20 64 | 65 6d 6f 20 76 65 72 73 |in the d|emo vers|
|00001d10| 69 6f 6e 2e 00 00 00 52 | 51 54 6f 6f 20 6d 61 6e |ion....R|QToo man|
|00001d20| 79 20 63 6f 6e 73 74 72 | 61 69 6e 74 20 63 65 6c |y constr|aint cel|
|00001d30| 6c 73 20 77 65 72 65 20 | 73 65 6c 65 63 74 65 64 |ls were |selected|
|00001d40| 2e 20 20 4c 69 6d 69 74 | 65 64 20 74 6f 20 38 20 |.  Limit|ed to 8 |
|00001d50| 63 65 6c 6c 73 20 69 6e | 20 74 68 65 20 64 65 6d |cells in| the dem|
|00001d60| 6f 20 76 65 72 73 69 6f | 6e 2e 00 00 00 41 40 54 |o versio|n....A@T|
|00001d70| 6f 6f 20 6d 61 6e 79 20 | 6f 62 6a 65 63 74 69 76 |oo many |objectiv|
|00001d80| 65 20 63 65 6c 6c 73 20 | 77 65 72 65 20 73 65 6c |e cells |were sel|
|00001d90| 65 63 74 65 64 2e 20 20 | 50 6c 65 61 73 65 20 73 |ected.  |Please s|
|00001da0| 65 6c 65 63 74 20 6a 75 | 73 74 20 6f 6e 65 2e 00 |elect ju|st one..|
|00001db0| 00 00 1e 1d 4b 65 79 20 | 6e 75 6d 62 65 72 20 69 |....Key |number i|
|00001dc0| 6e 20 6d 61 74 72 69 78 | 20 69 73 20 7a 65 72 6f |n matrix| is zero|
|00001dd0| 2e 00 00 00 33 32 54 68 | 65 20 6d 6f 64 65 6c 20 |....32Th|e model |
|00001de0| 69 73 20 6e 6f 6e 2d 6c | 69 6e 65 61 72 20 61 6e |is non-l|inear an|
|00001df0| 64 20 63 61 6e 27 74 20 | 62 65 20 6f 70 74 69 6d |d can't |be optim|
|00001e00| 69 7a 65 64 2e 20 20 20 | 00 00 00 40 3f 54 68 65 |ized.   |...@?The|
|00001e10| 20 6f 62 6a 65 63 74 69 | 76 65 20 63 65 6c 6c 20 | objecti|ve cell |
|00001e20| 68 61 73 20 61 6c 73 6f | 20 62 65 65 6e 20 73 65 |has also| been se|
|00001e30| 6c 65 63 74 65 64 20 61 | 73 20 61 20 63 6f 6e 73 |lected a|s a cons|
|00001e40| 74 72 61 69 6e 74 20 63 | 65 6c 6c 2e 00 00 00 30 |traint c|ell....0|
|00001e50| 2f 4f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 61 64 6a |/One or |more adj|
|00001e60| 75 73 74 61 62 6c 65 20 | 63 65 6c 6c 73 20 61 72 |ustable |cells ar|
|00001e70| 65 20 75 6e 63 6f 6e 73 | 74 72 61 69 6e 65 64 2e |e uncons|trained.|
|00001e80| 00 00 00 3e 3d 41 20 66 | 6f 72 6d 75 6c 61 20 69 |...>=A f|ormula i|
|00001e90| 6e 20 74 68 65 20 73 70 | 72 65 61 64 73 68 65 65 |n the sp|readshee|
|00001ea0| 74 20 72 65 66 65 72 73 | 20 74 6f 20 61 20 62 61 |t refers| to a ba|
|00001eb0| 64 20 6f 72 20 69 6e 76 | 61 6c 69 64 20 63 65 6c |d or inv|alid cel|
|00001ec0| 6c 2e 00 00 00 44 43 4e | 6f 20 66 65 61 73 69 62 |l....DCN|o feasib|
|00001ed0| 6c 65 20 73 6f 6c 75 74 | 69 6f 6e 20 65 78 69 73 |le solut|ion exis|
|00001ee0| 74 73 20 77 68 69 63 68 | 20 73 61 74 69 73 66 69 |ts which| satisfi|
|00001ef0| 65 73 20 61 6c 6c 20 6f | 66 20 74 68 65 20 63 6f |es all o|f the co|
|00001f00| 6e 73 74 72 61 69 6e 74 | 73 2e 00 00 00 29 28 54 |nstraint|s....)(T|
|00001f10| 68 65 20 73 6f 6c 75 74 | 69 6f 6e 20 66 6f 72 20 |he solut|ion for |
|00001f20| 74 68 65 20 6d 6f 64 65 | 6c 20 69 73 20 75 6e 62 |the mode|l is unb|
|00001f30| 6f 75 6e 64 65 64 2e 00 | 00 00 30 2f 55 6e 61 62 |ounded..|..0/Unab|
|00001f40| 6c 65 20 74 6f 20 72 65 | 61 64 20 73 70 72 65 61 |le to re|ad sprea|
|00001f50| 64 73 68 65 65 74 2e 20 | 20 49 6e 76 61 6c 69 64 |dsheet. | Invalid|
|00001f60| 20 53 59 4c 4b 20 66 69 | 6c 65 2e 00 00 00 3c 3b | SYLK fi|le....<;|
|00001f70| 55 6e 61 62 6c 65 20 74 | 6f 20 72 65 61 64 20 73 |Unable t|o read s|
|00001f80| 70 72 65 61 64 73 68 65 | 65 74 2e 20 20 49 6e 76 |preadshe|et.  Inv|
|00001f90| 61 6c 69 64 20 53 59 4c | 4b 20 70 61 72 6d 20 65 |alid SYL|K parm e|
|00001fa0| 6e 63 6f 75 6e 74 65 72 | 65 64 2e 00 00 00 41 40 |ncounter|ed....A@|
|00001fb0| 55 6e 61 62 6c 65 20 74 | 6f 20 72 65 61 64 20 73 |Unable t|o read s|
|00001fc0| 70 72 65 61 64 73 68 65 | 65 74 2e 20 20 49 6e 76 |preadshe|et.  Inv|
|00001fd0| 61 6c 69 64 20 58 2c 59 | 20 63 6f 6f 72 64 69 6e |alid X,Y| coordin|
|00001fe0| 61 74 65 20 65 6e 63 6f | 75 6e 74 65 72 65 64 2e |ate enco|untered.|
|00001ff0| 00 00 00 41 40 55 6e 61 | 62 6c 65 20 74 6f 20 72 |...A@Una|ble to r|
|00002000| 65 61 64 20 73 70 72 65 | 61 64 73 68 65 65 74 2e |ead spre|adsheet.|
|00002010| 20 20 4e 6f 20 63 65 6c | 6c 20 76 61 6c 75 65 20 |  No cel|l value |
|00002020| 66 6f 6c 6c 6f 77 65 64 | 20 4b 2d 53 59 4c 4b 20 |followed| K-SYLK |
|00002030| 70 61 72 6d 2e 00 00 00 | 44 43 55 6e 61 62 6c 65 |parm....|DCUnable|
|00002040| 20 74 6f 20 72 65 61 64 | 20 73 70 72 65 61 64 73 | to read| spreads|
|00002050| 68 65 65 74 2e 20 20 43 | 61 6e 27 74 20 65 76 61 |heet.  C|an't eva|
|00002060| 6c 75 61 74 65 20 66 6f | 72 6d 75 6c 61 20 69 6e |luate fo|rmula in|
|00002070| 20 73 70 72 65 61 64 73 | 68 65 65 74 2e 00 00 00 | spreads|heet....|
|00002080| 37 36 55 6e 61 62 6c 65 | 20 74 6f 20 72 65 61 64 |76Unable| to read|
|00002090| 20 73 70 72 65 61 64 73 | 68 65 65 74 2e 20 20 42 | spreads|heet.  B|
|000020a0| 6f 75 6e 64 73 20 65 72 | 72 6f 72 20 65 6e 63 6f |ounds er|ror enco|
|000020b0| 75 6e 74 65 72 65 64 2e | 00 00 00 1c 1b 55 6e 61 |untered.|.....Una|
|000020c0| 62 6c 65 20 74 6f 20 72 | 65 61 64 20 73 70 72 65 |ble to r|ead spre|
|000020d0| 61 64 73 68 65 65 74 2e | 00 00 00 36 35 55 6e 61 |adsheet.|...65Una|
|000020e0| 62 6c 65 20 74 6f 20 72 | 65 61 64 20 73 70 72 65 |ble to r|ead spre|
|000020f0| 61 64 73 68 65 65 74 2e | 20 20 43 61 6e 27 74 20 |adsheet.|  Can't |
|00002100| 66 69 6e 64 20 6f 72 20 | 6f 70 65 6e 20 66 69 6c |find or |open fil|
|00002110| 65 2e 00 00 00 59 58 4e | 75 6d 62 65 72 20 6f 66 |e....YXN|umber of|
|00002120| 20 74 65 78 74 20 63 65 | 6c 6c 73 20 65 78 63 65 | text ce|lls exce|
|00002130| 65 64 73 20 61 6c 6c 6f | 77 61 62 6c 65 20 6c 69 |eds allo|wable li|
|00002140| 6d 69 74 2e 20 20 54 72 | 79 20 72 65 6d 6f 76 69 |mit.  Tr|y removi|
|00002150| 6e 67 20 74 65 78 74 20 | 63 65 6c 6c 73 20 66 72 |ng text |cells fr|
|00002160| 6f 6d 20 73 70 72 65 61 | 64 73 68 65 65 74 2e 00 |om sprea|dsheet..|
|00002170| 00 00 5b 5a 4e 75 6d 62 | 65 72 20 6f 66 20 6e 75 |..[ZNumb|er of nu|
|00002180| 6d 65 72 69 63 20 63 65 | 6c 6c 73 20 65 78 63 65 |meric ce|lls exce|
|00002190| 65 64 73 20 61 6c 6c 6f | 77 61 62 6c 65 20 6c 69 |eds allo|wable li|
|000021a0| 6d 69 74 2e 20 20 54 72 | 79 20 6d 6f 76 69 6e 67 |mit.  Tr|y moving|
|000021b0| 20 6e 75 6d 65 72 69 63 | 20 76 61 6c 75 65 73 20 | numeric| values |
|000021c0| 69 6e 74 6f 20 66 6f 72 | 6d 75 6c 61 73 2e 00 00 |into for|mulas...|
|000021d0| 00 53 52 4e 75 6d 62 65 | 72 20 6f 66 20 66 6f 72 |.SRNumbe|r of for|
|000021e0| 6d 75 6c 61 73 20 65 78 | 63 65 65 64 73 20 61 6c |mulas ex|ceeds al|
|000021f0| 6c 6f 77 61 62 6c 65 20 | 6c 69 6d 69 74 2e 20 20 |lowable |limit.  |
|00002200| 54 72 79 20 6f 70 74 69 | 6d 69 7a 69 6e 67 20 61 |Try opti|mizing a|
|00002210| 20 73 6d 61 6c 6c 65 72 | 20 73 70 72 65 61 64 73 | smaller| spreads|
|00002220| 68 65 65 74 2e 00 00 00 | 83 82 4e 75 6d 62 65 72 |heet....|..Number|
|00002230| 20 6f 66 20 66 69 78 65 | 64 20 66 6f 72 6d 75 6c | of fixe|d formul|
|00002240| 61 73 20 65 78 63 65 65 | 64 73 20 61 6c 6c 6f 77 |as excee|ds allow|
|00002250| 61 62 6c 65 20 6c 69 6d | 69 74 2e 20 20 4d 61 6b |able lim|it.  Mak|
|00002260| 65 20 73 75 72 65 20 61 | 6c 6c 20 66 6f 72 6d 75 |e sure a|ll formu|
|00002270| 6c 61 73 20 75 73 65 20 | 73 74 61 6e 64 61 72 64 |las use |standard|
|00002280| 20 61 6c 67 65 62 72 61 | 69 63 20 6f 70 65 72 61 | algebra|ic opera|
|00002290| 74 69 6f 6e 73 20 28 2b | 2c 20 2d 2c 20 2a 2c 20 |tions (+|, -, *, |
|000022a0| 2f 2c 20 61 6e 64 20 53 | 55 4d 29 2e 00 00 00 49 |/, and S|UM)....I|
|000022b0| 48 55 6e 61 62 6c 65 20 | 74 6f 20 73 61 76 65 20 |HUnable |to save |
|000022c0| 73 70 72 65 61 64 73 68 | 65 65 74 2e 20 20 4e 6f |spreadsh|eet.  No|
|000022d0| 74 20 65 6e 6f 75 67 68 | 20 72 6f 6f 6d 20 6f 6e |t enough| room on|
|000022e0| 20 64 69 73 6b 20 66 6f | 72 20 61 20 77 6f 72 6b | disk fo|r a work|
|000022f0| 69 6e 67 20 63 6f 70 79 | 2e 00 00 00 36 35 55 6e |ing copy|....65Un|
|00002300| 61 62 6c 65 20 74 6f 20 | 73 61 76 65 20 73 70 72 |able to |save spr|
|00002310| 65 61 64 73 68 65 65 74 | 2e 20 20 4e 6f 74 20 65 |eadsheet|.  Not e|
|00002320| 6e 6f 75 67 68 20 72 6f | 6f 6d 20 6f 6e 20 64 69 |nough ro|om on di|
|00002330| 73 6b 2e 00 00 00 32 31 | 55 6e 61 62 6c 65 20 74 |sk....21|Unable t|
|00002340| 6f 20 73 61 76 65 20 73 | 70 72 65 61 64 73 68 65 |o save s|preadshe|
|00002350| 65 74 2e 20 20 43 61 6e | 27 74 20 77 72 69 74 65 |et.  Can|'t write|
|00002360| 20 74 6f 20 66 69 6c 65 | 2e 00 00 00 48 47 55 6e | to file|....HGUn|
|00002370| 61 62 6c 65 20 74 6f 20 | 73 61 76 65 20 73 70 72 |able to |save spr|
|00002380| 65 61 64 73 68 65 65 74 | 2e 20 20 50 72 65 6d 61 |eadsheet|.  Prema|
|00002390| 74 75 72 65 20 65 6f 66 | 2d 6f 66 2d 66 69 6c 65 |ture eof|-of-file|
|000023a0| 20 65 6e 63 6f 75 6e 74 | 65 72 65 64 20 6f 6e 20 | encount|ered on |
|000023b0| 66 69 6c 65 2e 00 00 00 | 41 40 55 6e 61 62 6c 65 |file....|A@Unable|
|000023c0| 20 74 6f 20 73 61 76 65 | 20 73 70 72 65 61 64 73 | to save| spreads|
|000023d0| 68 65 65 74 2e 20 20 49 | 6e 76 61 6c 69 64 20 58 |heet.  I|nvalid X|
|000023e0| 2c 59 20 63 6f 6f 72 64 | 69 6e 61 74 65 20 65 6e |,Y coord|inate en|
|000023f0| 63 6f 75 6e 74 65 72 65 | 64 2e 00 00 00 3c 3b 55 |countere|d....<;U|
|00002400| 6e 61 62 6c 65 20 74 6f | 20 73 61 76 65 20 73 70 |nable to| save sp|
|00002410| 72 65 61 64 73 68 65 65 | 74 2e 20 20 49 6e 76 61 |readshee|t.  Inva|
|00002420| 6c 69 64 20 53 59 4c 4b | 20 70 61 72 6d 20 65 6e |lid SYLK| parm en|
|00002430| 63 6f 75 6e 74 65 72 65 | 64 2e 00 00 00 35 34 55 |countere|d....54U|
|00002440| 6e 61 62 6c 65 20 74 6f | 20 73 61 76 65 20 73 70 |nable to| save sp|
|00002450| 72 65 61 64 73 68 65 65 | 74 2e 20 20 43 75 72 72 |readshee|t.  Curr|
|00002460| 65 6e 74 20 66 69 6c 65 | 20 6e 6f 74 20 66 6f 75 |ent file| not fou|
|00002470| 6e 64 2e 00 00 00 33 32 | 55 6e 61 62 6c 65 20 74 |nd....32|Unable t|
|00002480| 6f 20 73 61 76 65 20 73 | 70 72 65 61 64 73 68 65 |o save s|preadshe|
|00002490| 65 74 2e 20 20 43 75 72 | 72 65 6e 74 20 66 69 6c |et.  Cur|rent fil|
|000024a0| 65 20 69 73 20 62 75 73 | 79 2e 00 00 00 35 34 55 |e is bus|y....54U|
|000024b0| 6e 61 62 6c 65 20 74 6f | 20 73 61 76 65 20 73 70 |nable to| save sp|
|000024c0| 72 65 61 64 73 68 65 65 | 74 2e 20 20 46 69 6c 65 |readshee|t.  File|
|000024d0| 20 64 69 72 65 63 74 6f | 72 79 20 69 73 20 66 75 | directo|ry is fu|
|000024e0| 6c 6c 2e 00 00 00 37 36 | 55 6e 61 62 6c 65 20 74 |ll....76|Unable t|
|000024f0| 6f 20 73 61 76 65 20 73 | 70 72 65 61 64 73 68 65 |o save s|preadshe|
|00002500| 65 74 2e 20 20 4e 65 77 | 20 66 69 6c 65 20 6e 61 |et.  New| file na|
|00002510| 6d 65 20 69 73 20 69 6e | 76 61 6c 69 64 2e 00 00 |me is in|valid...|
|00002520| 00 35 34 55 6e 61 62 6c | 65 20 74 6f 20 73 61 76 |.54Unabl|e to sav|
|00002530| 65 20 73 70 72 65 61 64 | 73 68 65 65 74 2e 20 20 |e spread|sheet.  |
|00002540| 44 69 73 6b 20 6f 72 20 | 66 69 6c 65 20 69 73 20 |Disk or |file is |
|00002550| 6c 6f 63 6b 65 64 2e 00 | 00 00 36 35 55 6e 61 62 |locked..|..65Unab|
|00002560| 6c 65 20 74 6f 20 73 61 | 76 65 20 73 70 72 65 61 |le to sa|ve sprea|
|00002570| 64 73 68 65 65 74 2e 20 | 20 55 6e 6b 6e 6f 77 6e |dsheet. | Unknown|
|00002580| 20 6f 72 20 6d 69 73 73 | 69 6e 67 20 64 69 73 6b | or miss|ing disk|
|00002590| 2e 00 00 00 34 33 55 6e | 61 62 6c 65 20 74 6f 20 |....43Un|able to |
|000025a0| 73 61 76 65 20 73 70 72 | 65 61 64 73 68 65 65 74 |save spr|eadsheet|
|000025b0| 2e 20 20 43 61 6e 27 74 | 20 72 65 6e 61 6d 65 20 |.  Can't| rename |
|000025c0| 6e 65 77 20 66 69 6c 65 | 2e 00 00 00 3c 3b 55 6e |new file|....<;Un|
|000025d0| 61 62 6c 65 20 74 6f 20 | 65 76 61 6c 75 61 74 65 |able to |evaluate|
|000025e0| 20 66 6f 72 6d 75 6c 61 | 2c 20 63 61 6e 74 20 64 | formula|, cant d|
|000025f0| 65 2d 62 6c 6f 63 6b 20 | 74 6f 6b 65 6e 20 69 6e |e-block |token in|
|00002600| 20 66 6f 72 6d 75 6c 61 | 2e 00 00 00 3d 3c 46 6f | formula|....=<Fo|
|00002610| 72 6d 75 6c 61 20 69 73 | 20 6e 65 73 74 65 64 20 |rmula is| nested |
|00002620| 74 6f 6f 20 64 65 65 70 | 6c 79 2e 20 20 4d 61 78 |too deep|ly.  Max|
|00002630| 69 6d 75 6d 20 73 74 61 | 63 6b 20 64 65 70 74 68 |imum sta|ck depth|
|00002640| 20 65 78 63 65 65 64 65 | 64 2e 00 00 00 15 14 42 | exceede|d......B|
|00002650| 61 64 20 4f 74 68 65 72 | 77 69 73 65 20 54 61 6b |ad Other|wise Tak|
|00002660| 65 6e 2e 00 00 00 02 00 | 2b 00 00 00 02 00 1d 00 |en......|+.......|
|00002670| 00 00 02 00 09 00 00 00 | 02 00 0a 00 00 00 02 00 |........|........|
|00002680| 0b 00 00 00 02 00 23 00 | 00 00 02 00 23 00 00 00 |......#.|....#...|
|00002690| 02 00 1b 00 00 00 02 00 | 1b 00 00 00 02 00 18 00 |........|........|
|000026a0| 00 00 02 00 17 00 00 00 | 02 00 09 00 00 00 02 00 |........|........|
|000026b0| 0a 00 00 00 02 00 0b 00 | 00 00 02 00 1a 00 00 00 |........|........|
|000026c0| 02 00 0b 00 00 00 02 00 | 09 00 00 00 02 00 2a 00 |........|......*.|
|000026d0| 00 00 02 00 27 00 00 00 | 02 00 28 00 00 00 02 00 |....'...|..(.....|
|000026e0| 08 00 00 00 02 00 08 00 | 00 00 02 00 08 00 00 00 |........|........|
|000026f0| 02 00 08 00 00 00 02 00 | 08 00 00 00 02 00 08 00 |........|........|
|00002700| 00 00 02 00 08 00 00 00 | 02 00 2d 00 00 00 02 00 |........|..-.....|
|00002710| 2d 00 00 00 02 00 2d 00 | 00 00 02 00 2d 00 00 00 |-.....-.|....-...|
|00002720| 02 00 20 00 00 00 02 00 | 1f 00 00 00 02 00 2d 00 |.. .....|......-.|
|00002730| 00 00 02 00 2d 00 00 00 | 02 00 2d 00 00 00 02 00 |....-...|..-.....|
|00002740| 2d 00 00 00 02 00 20 00 | 00 00 02 00 20 00 00 00 |-..... .|.... ...|
|00002750| 02 00 20 00 00 00 02 00 | 2d 00 00 00 02 00 20 00 |.. .....|-..... .|
|00002760| 00 00 02 00 2d 00 00 00 | 02 00 2d 00 00 03 9f 00 |....-...|..-.....|
|00002770| 2d 11 4f 72 64 65 72 20 | 49 6e 66 6f 72 6d 61 74 |-.Order |Informat|
|00002780| 69 6f 6e 0c 49 6e 74 72 | 6f 64 75 63 74 69 6f 6e |ion.Intr|oduction|
|00002790| 18 20 20 20 57 68 61 74 | 20 69 73 20 42 65 73 74 |.   What| is Best|
|000027a0| 20 41 6e 73 77 65 72 aa | 3f 14 20 20 20 48 6f 77 | Answer.|?.   How|
|000027b0| 20 44 6f 65 73 20 69 74 | 20 57 6f 72 6b 3f 12 20 | Does it| Work?. |
|000027c0| 20 20 41 20 46 65 77 20 | 4e 65 77 20 54 65 72 6d |  A Few |New Term|
|000027d0| 73 0d 20 20 20 49 6e 20 | 53 75 6d 6d 61 72 79 0c |s.   In |Summary.|
|000027e0| 42 61 73 69 63 20 54 6f | 70 69 63 73 13 20 20 20 |Basic To|pics.   |
|000027f0| 4c 6f 61 64 20 53 70 72 | 65 61 64 73 68 65 65 74 |Load Spr|eadsheet|
|00002800| 20 20 20 20 44 65 66 69 | 6e 69 6e 67 20 41 64 6a |    Defi|ning Adj|
|00002810| 75 73 74 61 62 6c 65 20 | 43 65 6c 6c 73 20 20 20 |ustable |Cells   |
|00002820| 20 1c 20 20 20 44 65 66 | 69 6e 69 6e 67 20 43 6f | .   Def|ining Co|
|00002830| 6e 73 74 72 61 69 6e 74 | 20 43 65 6c 6c 73 1e 20 |nstraint| Cells. |
|00002840| 20 20 44 65 66 69 6e 69 | 6e 67 20 74 68 65 20 4f |  Defini|ng the O|
|00002850| 62 6a 65 63 74 69 76 65 | 20 43 65 6c 6c 0f 20 20 |bjective| Cell.  |
|00002860| 20 4f 70 74 69 6d 69 7a | 61 74 69 6f 6e 1b 20 20 | Optimiz|ation.  |
|00002870| 20 53 77 69 74 63 68 65 | 72 20 61 6e 64 20 4d 75 | Switche|r and Mu|
|00002880| 6c 74 69 66 69 6e 64 65 | 72 12 20 20 20 45 78 63 |ltifinde|r.   Exc|
|00002890| 65 6c 20 46 75 6e 63 74 | 69 6f 6e 73 08 45 78 61 |el Funct|ions.Exa|
|000028a0| 6d 70 6c 65 73 1a 20 20 | 20 31 29 20 50 72 6f 64 |mples.  | 1) Prod|
|000028b0| 75 63 74 20 4d 69 78 20 | 50 6c 61 6e 6e 69 6e 67 |uct Mix |Planning|
|000028c0| 0e 20 20 20 32 29 20 42 | 6c 65 6e 64 69 6e 67 15 |.   2) B|lending.|
|000028d0| 20 20 20 33 29 20 4d 65 | 64 69 61 20 53 65 6c 65 |   3) Me|dia Sele|
|000028e0| 63 74 69 6f 6e 18 20 20 | 20 34 29 20 43 61 73 68 |ction.  | 4) Cash|
|000028f0| 20 46 6c 6f 77 20 41 6e | 61 6c 79 73 69 73 16 20 | Flow An|alysis. |
|00002900| 20 20 35 29 20 53 74 61 | 66 66 20 53 63 68 65 64 |  5) Sta|ff Sched|
|00002910| 75 6c 69 6e 67 1a 20 20 | 20 36 29 20 50 6f 72 74 |uling.  | 6) Port|
|00002920| 66 6f 6c 69 6f 20 53 65 | 6c 65 63 74 69 6f 6e 20 |folio Se|lection |
|00002930| 14 53 65 6e 73 69 74 69 | 76 69 74 79 20 41 6e 61 |.Sensiti|vity Ana|
|00002940| 6c 79 73 69 73 0f 20 20 | 20 53 68 61 64 6f 77 20 |lysis.  | Shadow |
|00002950| 50 72 69 63 65 15 20 20 | 20 43 6f 6e 74 72 69 62 |Price.  | Contrib|
|00002960| 75 74 69 6f 6e 20 52 61 | 6e 67 65 0a 52 65 66 65 |ution Ra|nge.Refe|
|00002970| 72 65 6e 63 65 3a 0c 20 | 20 20 4c 69 6e 65 61 72 |rence:. |  Linear|
|00002980| 69 74 79 13 20 20 20 43 | 68 61 6e 67 69 6e 67 20 |ity.   C|hanging |
|00002990| 56 61 6c 75 65 73 20 1f | 20 20 20 4d 6f 72 65 20 |Values .|   More |
|000029a0| 41 62 6f 75 74 20 43 6f | 6e 73 74 72 61 69 6e 74 |About Co|nstraint|
|000029b0| 20 43 65 6c 6c 73 20 12 | 20 20 20 53 65 6c 65 63 | Cells .|   Selec|
|000029c0| 74 69 6e 67 20 43 65 6c | 6c 73 08 20 20 20 4d 65 |ting Cel|ls.   Me|
|000029d0| 6e 75 73 10 20 20 20 20 | 20 20 41 70 70 6c 65 20 |nus.    |  Apple |
|000029e0| 4d 65 6e 75 0f 20 20 20 | 20 20 20 46 69 6c 65 20 |Menu.   |   File |
|000029f0| 4d 65 6e 75 0f 20 20 20 | 20 20 20 45 64 69 74 20 |Menu.   |   Edit |
|00002a00| 4d 65 6e 75 11 20 20 20 | 20 20 20 46 6f 72 6d 61 |Menu.   |   Forma|
|00002a10| 74 20 4d 65 6e 75 10 20 | 20 20 20 20 20 43 65 6c |t Menu. |     Cel|
|00002a20| 6c 20 4d 65 6e 75 20 17 | 20 20 20 20 20 20 4f 70 |l Menu .|      Op|
|00002a30| 74 69 6d 69 7a 61 74 69 | 6f 6e 20 4d 65 6e 75 19 |timizati|on Menu.|
|00002a40| 20 20 20 53 70 72 65 61 | 64 73 68 65 65 74 20 46 |   Sprea|dsheet F|
|00002a50| 6f 72 6d 61 74 74 69 6e | 67 18 20 20 20 45 72 72 |ormattin|g.   Err|
|00002a60| 6f 72 73 20 61 6e 64 20 | 45 78 63 65 70 74 69 6f |ors and |Exceptio|
|00002a70| 6e 73 13 20 20 20 20 20 | 20 49 6e 66 65 61 73 69 |ns.     | Infeasi|
|00002a80| 62 69 6c 69 74 79 13 20 | 20 20 20 20 20 55 6e 62 |bility. |     Unb|
|00002a90| 6f 75 6e 64 65 64 6e 65 | 73 73 1e 20 20 20 20 20 |oundedne|ss.     |
|00002aa0| 20 46 69 78 65 64 20 46 | 6f 72 6d 75 6c 61 73 20 | Fixed F|ormulas |
|00002ab0| 28 49 74 61 6c 69 63 73 | 29 20 20 20 20 20 20 20 |(Italics|)       |
|00002ac0| 49 6e 76 61 6c 69 64 20 | 6e 75 6d 62 65 72 73 20 |Invalid |numbers |
|00002ad0| 28 4e 41 4e 2c 20 49 4e | 46 29 13 20 20 20 20 20 |(NAN, IN|F).     |
|00002ae0| 20 4f 75 74 20 6f 66 20 | 4d 65 6d 6f 72 79 14 20 | Out of |Memory. |
|00002af0| 20 20 20 20 20 45 72 72 | 6f 72 20 4d 65 73 73 61 |     Err|or Messa|
|00002b00| 67 65 73 0a 20 20 20 53 | 75 70 70 6f 72 74 00 00 |ges.   S|upport..|
|00002b10| 03 cc 00 19 3e 57 65 6c | 63 6f 6d 65 20 74 6f 20 |....>Wel|come to |
|00002b20| 74 68 65 20 64 65 6d 6f | 6e 73 74 72 61 74 69 6f |the demo|nstratio|
|00002b30| 6e 20 76 65 72 73 69 6f | 6e 20 6f 66 20 42 65 73 |n versio|n of Bes|
|00002b40| 74 20 41 6e 73 77 65 72 | aa 2c 20 61 20 62 72 65 |t Answer|., a bre|
|00002b50| 61 6b 2d 3d 74 68 72 6f | 75 67 68 20 69 6e 20 64 |ak-=thro|ugh in d|
|00002b60| 65 63 69 73 69 6f 6e 20 | 73 75 70 70 6f 72 74 20 |ecision |support |
|00002b70| 66 6f 72 20 4d 69 63 72 | 6f 73 6f 66 74 a8 20 73 |for Micr|osoft. s|
|00002b80| 70 72 65 61 64 73 68 65 | 65 74 20 75 73 65 72 73 |preadshe|et users|
|00002b90| 2e 00 3c 41 66 74 65 72 | 20 65 78 70 65 72 69 6d |..<After| experim|
|00002ba0| 65 6e 74 69 6e 67 20 77 | 69 74 68 20 74 68 69 73 |enting w|ith this|
|00002bb0| 20 6c 69 6d 69 74 65 64 | 20 76 65 72 73 69 6f 6e | limited| version|
|00002bc0| 2c 20 79 6f 75 20 6d 61 | 79 20 6f 72 64 65 72 1b |, you ma|y order.|
|00002bd0| 42 65 73 74 20 41 6e 73 | 77 65 72 aa 20 62 79 20 |Best Ans|wer. by |
|00002be0| 63 6f 6e 74 61 63 74 69 | 6e 67 3a 00 29 20 20 20 |contacti|ng:.)   |
|00002bf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002c00| 20 20 20 20 20 20 20 48 | 65 69 7a 65 72 20 53 6f |       H|eizer So|
|00002c10| 66 74 77 61 72 65 36 20 | 20 20 20 20 20 20 20 20 |ftware6 |        |
|00002c20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002c30| 20 31 39 34 31 20 4f 61 | 6b 20 50 61 72 6b 20 42 | 1941 Oa|k Park B|
|00002c40| 6c 76 64 2c 20 53 75 69 | 74 65 20 33 30 31 20 20 |lvd, Sui|te 301  |
|00002c50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002c60| 20 20 20 20 20 20 20 20 | 50 6c 65 61 73 61 6e 74 |        |Pleasant|
|00002c70| 20 48 69 6c 6c 2c 20 43 | 41 20 39 34 35 32 33 12 | Hill, C|A 94523.|
|00002c80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002c90| 20 20 31 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |  1     |        |
|00002ca0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002cb0| 20 20 20 20 2d 2d 20 6f | 72 20 62 79 20 63 61 6c |    -- o|r by cal|
|00002cc0| 6c 69 6e 67 00 3f 20 20 | 20 20 20 20 20 20 20 20 |ling.?  |        |
|00002cd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002ce0| 31 2d 38 30 30 2d 32 32 | 35 2d 36 37 35 35 20 20 |1-800-22|5-6755  |
|00002cf0| 20 28 6f 75 74 73 69 64 | 65 20 43 61 6c 69 66 6f | (outsid|e Califo|
|00002d00| 72 6e 69 61 29 3e 20 20 | 20 20 20 20 20 20 20 20 |rnia)>  |        |
|00002d10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002d20| 31 2d 34 31 35 2d 39 34 | 33 2d 37 36 36 37 20 20 |1-415-94|3-7667  |
|00002d30| 20 28 69 6e 73 69 64 65 | 20 43 61 6c 69 66 6f 72 | (inside| Califor|
|00002d40| 6e 69 61 29 0f 20 20 20 | 20 20 20 20 20 20 20 20 |nia).   |        |
|00002d50| 20 20 20 20 3a 46 6f 72 | 20 74 68 65 20 4d 69 63 |    :For| the Mic|
|00002d60| 72 6f 73 6f 66 74 a8 20 | 45 78 63 65 6c 20 76 65 |rosoft. |Excel ve|
|00002d70| 72 73 69 6f 6e 2c 20 20 | 61 73 6b 20 66 6f 72 20 |rsion,  |ask for |
|00002d80| 70 72 6f 67 72 61 6d 20 | 23 31 30 34 35 32 2e 39 |program |#10452.9|
|00002d90| 46 6f 72 20 74 68 65 20 | 4d 69 63 72 6f 73 6f 66 |For the |Microsof|
|00002da0| 74 a8 20 57 6f 72 6b 73 | 20 76 65 72 73 69 6f 6e |t. Works| version|
|00002db0| 2c 20 61 73 6b 20 66 6f | 72 20 70 72 6f 67 72 61 |, ask fo|r progra|
|00002dc0| 6d 20 23 32 30 31 39 32 | 2e 00 2b 42 65 73 74 20 |m #20192|..+Best |
|00002dd0| 41 6e 73 77 65 72 aa 27 | 73 20 72 65 74 61 69 6c |Answer.'|s retail|
|00002de0| 20 70 72 69 63 65 20 69 | 73 20 6f 6e 6c 79 20 24 | price i|s only $|
|00002df0| 39 39 2e 30 30 2e 00 41 | 49 6e 20 61 64 64 69 74 |99.00..A|In addit|
|00002e00| 69 6f 6e 20 74 6f 20 64 | 69 73 74 72 69 62 75 74 |ion to d|istribut|
|00002e10| 69 6e 67 20 42 65 73 74 | 20 41 6e 73 77 65 72 aa |ing Best| Answer.|
|00002e20| 2c 20 48 65 69 7a 65 72 | 20 53 6f 66 74 77 61 72 |, Heizer| Softwar|
|00002e30| 65 20 61 63 74 73 20 61 | 73 42 61 20 63 6c 65 61 |e acts a|sBa clea|
|00002e40| 72 69 6e 67 20 68 6f 75 | 73 65 20 66 6f 72 20 6d |ring hou|se for m|
|00002e50| 6f 72 65 20 74 68 61 6e | 20 37 30 30 20 74 65 6d |ore than| 700 tem|
|00002e60| 70 6c 61 74 65 73 2c 20 | 74 75 74 6f 72 69 61 6c |plates, |tutorial|
|00002e70| 73 2c 20 61 6e 64 20 64 | 61 74 61 2d 26 62 61 73 |s, and d|ata-&bas|
|00002e80| 65 73 20 66 6f 72 20 45 | 78 63 65 6c 2c 20 57 6f |es for E|xcel, Wo|
|00002e90| 72 6b 73 2c 20 61 6e 64 | 20 48 79 70 65 72 63 61 |rks, and| Hyperca|
|00002ea0| 72 64 2e 00 39 43 6c 69 | 63 6b 20 74 68 65 20 4e |rd..9Cli|ck the N|
|00002eb0| 45 58 54 20 62 75 74 74 | 6f 6e 20 74 6f 20 70 72 |EXT butt|on to pr|
|00002ec0| 6f 63 65 65 64 20 74 6f | 20 74 68 65 20 6f 6e 2d |oceed to| the on-|
|00002ed0| 6c 69 6e 65 20 74 75 74 | 6f 72 69 61 6c 2e 00 00 |line tut|orial...|
|00002ee0| 05 62 00 1c 3f 42 65 73 | 74 20 41 6e 73 77 65 72 |.b..?Bes|t Answer|
|00002ef0| aa 20 69 73 20 61 6e 20 | 22 61 64 64 2d 6f 6e 22 |. is an |"add-on"|
|00002f00| 20 74 6f 20 4d 69 63 72 | 6f 73 6f 66 74 a8 20 45 | to Micr|osoft. E|
|00002f10| 78 63 65 6c 2e 20 20 53 | 69 6e 63 65 20 79 6f 75 |xcel.  S|ince you|
|00002f20| 20 61 72 65 43 61 6c 72 | 65 61 64 79 20 66 61 6d | areCalr|eady fam|
|00002f30| 69 6c 69 61 72 20 77 69 | 74 68 20 45 78 63 65 6c |iliar wi|th Excel|
|00002f40| 20 79 6f 75 20 72 65 61 | 6c 6c 79 20 68 61 76 65 | you rea|lly have|
|00002f50| 20 76 65 72 79 20 6c 69 | 74 74 6c 65 20 74 6f 20 | very li|ttle to |
|00002f60| 6c 65 61 72 6e 2e 20 20 | 42 59 6f 75 20 73 69 6d |learn.  |BYou sim|
|00002f70| 70 6c 79 20 63 72 65 61 | 74 65 20 79 6f 75 72 20 |ply crea|te your |
|00002f80| 73 70 72 65 61 64 73 68 | 65 65 74 20 69 6e 20 45 |spreadsh|eet in E|
|00002f90| 78 63 65 6c 20 28 6c 69 | 6b 65 20 79 6f 75 20 75 |xcel (li|ke you u|
|00002fa0| 73 75 61 6c 6c 79 20 64 | 6f 29 2c 41 74 68 65 6e |sually d|o),Athen|
|00002fb0| 20 6c 6f 61 64 20 69 74 | 20 69 6e 74 6f 20 42 65 | load it| into Be|
|00002fc0| 73 74 20 41 6e 73 77 65 | 72 aa 2c 20 77 68 69 63 |st Answe|r., whic|
|00002fd0| 68 20 77 69 6c 6c 20 68 | 65 6c 70 20 79 6f 75 20 |h will h|elp you |
|00002fe0| 61 72 72 69 76 65 20 61 | 74 20 74 68 65 39 62 65 |arrive a|t the9be|
|00002ff0| 73 74 20 70 6f 73 73 69 | 62 6c 65 20 61 6e 73 77 |st possi|ble answ|
|00003000| 65 72 20 66 6f 72 20 79 | 6f 75 72 20 63 75 72 72 |er for y|our curr|
|00003010| 65 6e 74 20 62 75 73 69 | 6e 65 73 73 20 73 69 74 |ent busi|ness sit|
|00003020| 75 61 74 69 6f 6e 2e 00 | 42 59 6f 75 20 64 6f 6e |uation..|BYou don|
|00003030| 27 74 20 6e 65 65 64 20 | 61 20 63 6f 6d 70 6c 69 |'t need |a compli|
|00003040| 63 61 74 65 64 20 6d 61 | 6e 75 61 6c 21 20 20 41 |cated ma|nual!  A|
|00003050| 63 74 75 61 6c 6c 79 2c | 20 79 6f 75 20 61 6c 72 |ctually,| you alr|
|00003060| 65 61 64 79 20 6b 6e 6f | 77 20 61 3e 6c 6f 74 20 |eady kno|w a>lot |
|00003070| 61 62 6f 75 74 20 68 6f | 77 20 42 65 73 74 20 41 |about ho|w Best A|
|00003080| 6e 73 77 65 72 aa 20 77 | 6f 72 6b 73 20 62 65 63 |nswer. w|orks bec|
|00003090| 61 75 73 65 20 69 74 20 | 69 73 20 62 61 73 65 64 |ause it |is based|
|000030a0| 20 6f 6e 20 45 78 63 65 | 6c 2e 41 54 68 65 72 65 | on Exce|l.AThere|
|000030b0| 20 61 72 65 20 61 20 66 | 65 77 20 6e 65 77 20 66 | are a f|ew new f|
|000030c0| 75 6e 63 74 69 6f 6e 73 | 20 79 6f 75 20 77 69 6c |unctions| you wil|
|000030d0| 6c 20 6e 65 65 64 20 74 | 6f 20 6c 65 61 72 6e 2e |l need t|o learn.|
|000030e0| 20 20 46 6f 6c 6c 6f 77 | 20 74 68 65 3f 73 74 65 |  Follow| the?ste|
|000030f0| 70 73 20 62 65 6c 6f 77 | 20 74 6f 20 66 61 6d 69 |ps below| to fami|
|00003100| 6c 69 61 72 69 7a 65 20 | 79 6f 75 72 73 65 6c 66 |liarize |yourself|
|00003110| 20 77 69 74 68 20 68 6f | 77 20 74 68 65 20 70 72 | with ho|w the pr|
|00003120| 6f 67 72 61 6d 20 77 6f | 72 6b 73 3a 00 43 20 20 |ogram wo|rks:.C  |
|00003130| 20 31 29 20 20 46 69 72 | 73 74 2c 20 72 65 61 64 | 1)  Fir|st, read|
|00003140| 20 74 68 65 20 72 65 73 | 74 20 6f 66 20 74 68 65 | the res|t of the|
|00003150| 20 49 4e 54 52 4f 44 55 | 43 54 49 4f 4e 20 73 65 | INTRODU|CTION se|
|00003160| 63 74 69 6f 6e 2e 20 20 | 54 68 69 73 20 77 69 6c |ction.  |This wil|
|00003170| 6c 43 20 20 20 20 20 20 | 20 20 20 67 69 76 65 20 |lC      |   give |
|00003180| 79 6f 75 20 61 6e 20 6f | 76 65 72 76 69 65 77 20 |you an o|verview |
|00003190| 6f 66 20 42 65 73 74 20 | 41 6e 73 77 65 72 aa 2e |of Best |Answer..|
|000031a0| 20 20 49 74 20 77 69 6c | 6c 20 65 78 70 6c 61 69 |  It wil|l explai|
|000031b0| 6e 20 74 68 65 3a 20 20 | 20 20 20 20 20 20 20 62 |n the:  |       b|
|000031c0| 61 73 69 63 73 20 6f 66 | 20 74 68 65 20 70 72 6f |asics of| the pro|
|000031d0| 67 72 61 6d 20 61 6e 64 | 20 64 65 66 69 6e 65 20 |gram and| define |
|000031e0| 61 20 66 65 77 20 6e 65 | 77 20 74 65 72 6d 73 2e |a few ne|w terms.|
|000031f0| 05 20 20 20 20 20 3f 20 | 20 20 20 32 29 20 20 4e |.     ? |   2)  N|
|00003200| 65 78 74 2c 20 72 65 61 | 64 20 74 68 72 6f 75 67 |ext, rea|d throug|
|00003210| 68 20 74 68 65 20 42 41 | 53 49 43 20 54 4f 50 49 |h the BA|SIC TOPI|
|00003220| 43 53 20 73 65 63 74 69 | 6f 6e 20 6f 66 20 74 68 |CS secti|on of th|
|00003230| 65 20 48 45 4c 50 40 20 | 20 20 20 20 20 20 20 20 |e HELP@ |        |
|00003240| 20 6d 65 6e 75 20 74 6f | 20 66 75 72 74 68 65 72 | menu to| further|
|00003250| 20 66 61 6d 69 6c 69 61 | 72 69 7a 65 20 79 6f 75 | familia|rize you|
|00003260| 72 73 65 6c 66 20 77 69 | 74 68 20 74 68 65 20 70 |rself wi|th the p|
|00003270| 72 6f 67 72 61 6d 2e 05 | 20 20 20 20 20 3e 20 20 |rogram..|     >  |
|00003280| 20 33 29 20 20 54 68 65 | 6e 2c 20 67 6f 20 74 68 | 3)  The|n, go th|
|00003290| 72 6f 75 67 68 20 61 20 | 66 65 77 20 45 58 41 4d |rough a |few EXAM|
|000032a0| 50 4c 45 53 20 74 6f 20 | 67 65 74 20 73 6f 6d 65 |PLES to |get some|
|000032b0| 20 22 68 61 6e 64 73 2d | 6f 6e 22 20 47 20 20 20 | "hands-|on" G   |
|000032c0| 20 20 20 20 20 20 20 65 | 78 70 65 72 69 65 6e 63 |       e|xperienc|
|000032d0| 65 2e 20 20 54 68 69 73 | 20 77 69 6c 6c 20 67 69 |e.  This| will gi|
|000032e0| 76 65 20 79 6f 75 20 61 | 6e 20 69 64 65 61 20 6f |ve you a|n idea o|
|000032f0| 66 20 74 68 65 20 6d 61 | 6e 79 20 64 69 66 66 65 |f the ma|ny diffe|
|00003300| 72 65 6e 74 36 20 20 20 | 20 20 20 20 20 20 20 74 |rent6   |       t|
|00003310| 79 70 65 73 20 6f 66 20 | 73 69 74 75 61 74 69 6f |ypes of |situatio|
|00003320| 6e 73 20 42 65 73 74 20 | 41 6e 73 77 65 72 aa 20 |ns Best |Answer. |
|00003330| 63 61 6e 20 68 61 6e 64 | 6c 65 2e 00 3c 4e 6f 74 |can hand|le..<Not|
|00003340| 65 3a 20 20 42 65 73 74 | 20 41 6e 73 77 65 72 aa |e:  Best| Answer.|
|00003350| 20 69 73 20 61 6c 73 6f | 20 63 6f 6d 70 61 74 69 | is also| compati|
|00003360| 62 6c 65 20 77 69 74 68 | 20 4d 69 63 72 6f 73 6f |ble with| Microso|
|00003370| 66 74 a8 20 57 6f 72 6b | 73 29 20 20 20 20 20 20 |ft. Work|s)      |
|00003380| 20 20 20 20 20 61 6e 64 | 20 4d 69 63 72 6f 73 6f |     and| Microso|
|00003390| 66 74 a8 20 4d 75 6c 74 | 69 70 6c 61 6e 2e 20 20 |ft. Mult|iplan.  |
|000033a0| 20 20 20 05 20 20 20 20 | 20 3b 4e 4f 57 20 2d 2d |   .    | ;NOW --|
|000033b0| 20 50 72 6f 63 65 65 64 | 20 77 69 74 68 20 74 68 | Proceed| with th|
|000033c0| 65 20 49 4e 54 52 4f 44 | 55 43 54 49 4f 4e 20 62 |e INTROD|UCTION b|
|000033d0| 79 20 63 6c 69 63 6b 69 | 6e 67 20 74 68 65 20 22 |y clicki|ng the "|
|000033e0| 4e 65 78 74 22 45 20 20 | 20 20 20 20 20 20 20 20 |Next"E  |        |
|000033f0| 20 20 20 20 62 75 74 74 | 6f 6e 20 61 74 20 74 68 |    butt|on at th|
|00003400| 65 20 62 6f 74 74 6f 6d | 20 6f 66 20 74 68 65 20 |e bottom| of the |
|00003410| 73 63 72 65 65 6e 20 28 | 6f 72 20 70 72 65 73 73 |screen (|or press|
|00003420| 20 22 4e 22 20 6f 6e 20 | 74 68 65 18 20 20 20 20 | "N" on |the.    |
|00003430| 20 20 20 20 20 20 20 20 | 20 20 6b 65 79 62 6f 61 |        |  keyboa|
|00003440| 72 64 29 2e 00 00 03 9d | 00 13 3b 42 65 73 74 20 |rd).....|..;Best |
|00003450| 41 6e 73 77 65 72 aa 20 | 69 73 20 61 6e 20 4f 50 |Answer. |is an OP|
|00003460| 54 49 4d 49 5a 41 54 49 | 4f 4e 20 70 72 6f 67 72 |TIMIZATI|ON progr|
|00003470| 61 6d 2e 20 20 49 74 20 | 61 6c 6c 6f 77 73 20 79 |am.  It |allows y|
|00003480| 6f 75 20 74 6f 20 3b 4f | 50 54 49 4d 49 5a 45 20 |ou to ;O|PTIMIZE |
|00003490| 28 6d 61 78 69 6d 69 7a | 65 20 6f 72 20 6d 69 6e |(maximiz|e or min|
|000034a0| 69 6d 69 7a 65 29 20 61 | 20 67 69 76 65 6e 20 62 |imize) a| given b|
|000034b0| 75 73 69 6e 65 73 73 20 | 73 69 74 75 61 74 69 6f |usiness |situatio|
|000034c0| 6e 2e 3f 54 68 69 73 20 | 6d 61 79 20 62 65 20 74 |n.?This |may be t|
|000034d0| 6f 20 6d 61 78 69 6d 69 | 7a 65 20 79 6f 75 72 20 |o maximi|ze your |
|000034e0| 70 72 6f 66 69 74 73 20 | 6f 72 20 74 6f 20 6d 69 |profits |or to mi|
|000034f0| 6e 69 6d 69 7a 65 20 79 | 6f 75 72 20 63 6f 73 74 |nimize y|our cost|
|00003500| 73 2e 00 41 42 65 73 74 | 20 41 6e 73 77 65 72 aa |s..ABest| Answer.|
|00003510| 20 68 65 6c 70 73 20 79 | 6f 75 20 61 6e 61 6c 79 | helps y|ou analy|
|00003520| 7a 65 20 79 6f 75 72 20 | 73 69 74 75 61 74 69 6f |ze your |situatio|
|00003530| 6e 20 73 6f 20 74 68 61 | 74 20 79 6f 75 20 63 61 |n so tha|t you ca|
|00003540| 6e 20 67 65 74 3e 74 68 | 65 20 62 65 73 74 20 72 |n get>th|e best r|
|00003550| 65 73 75 6c 74 73 20 77 | 69 74 68 6f 75 74 20 68 |esults w|ithout h|
|00003560| 61 76 69 6e 67 20 74 6f | 20 6d 61 6e 69 70 75 6c |aving to| manipul|
|00003570| 61 74 65 20 6c 61 72 67 | 65 20 6e 75 6d 62 65 72 |ate larg|e number|
|00003580| 73 20 6f 66 3e 76 61 72 | 69 61 62 6c 65 73 20 28 |s of>var|iables (|
|00003590| 41 44 4a 55 53 54 41 42 | 4c 45 53 29 20 62 79 20 |ADJUSTAB|LES) by |
|000035a0| 68 61 6e 64 2e 20 20 49 | 6e 20 6d 61 6b 69 6e 67 |hand.  I|n making|
|000035b0| 20 62 75 73 69 6e 65 73 | 73 20 64 65 63 69 73 69 | busines|s decisi|
|000035c0| 6f 6e 73 45 79 6f 75 20 | 64 6f 20 74 68 69 73 20 |onsEyou |do this |
|000035d0| 61 6c 6c 20 74 68 65 20 | 74 69 6d 65 2e 20 20 4e |all the |time.  N|
|000035e0| 6f 74 20 6f 6e 6c 79 20 | 69 73 20 74 68 69 73 20 |ot only |is this |
|000035f0| 22 57 68 61 74 20 69 66 | 2e 2e 2e 22 20 70 72 6f |"What if|..." pro|
|00003600| 63 65 73 73 20 74 69 6d | 65 40 63 6f 6e 73 75 6d |cess tim|e@consum|
|00003610| 69 6e 67 2c 20 62 75 74 | 20 79 6f 75 20 61 72 65 |ing, but| you are|
|00003620| 20 6e 65 76 65 72 20 71 | 75 69 74 65 20 73 75 72 | never q|uite sur|
|00003630| 65 20 77 68 65 6e 20 79 | 6f 75 20 68 61 76 65 20 |e when y|ou have |
|00003640| 61 72 72 69 76 65 64 20 | 61 74 1c 74 68 65 20 22 |arrived |at.the "|
|00003650| 62 65 73 74 20 70 6f 73 | 73 69 62 6c 65 20 61 6e |best pos|sible an|
|00003660| 73 77 65 72 22 2e 20 00 | 39 42 65 73 74 20 41 6e |swer". .|9Best An|
|00003670| 73 77 65 72 aa 20 75 73 | 65 73 20 61 20 6d 61 74 |swer. us|es a mat|
|00003680| 68 65 6d 61 74 69 63 61 | 6c 20 74 65 63 68 6e 69 |hematica|l techni|
|00003690| 71 75 65 20 63 61 6c 6c | 65 64 20 22 6c 69 6e 65 |que call|ed "line|
|000036a0| 61 72 3d 70 72 6f 67 72 | 61 6d 6d 69 6e 67 22 20 |ar=progr|amming" |
|000036b0| 74 6f 20 64 65 74 65 72 | 6d 69 6e 65 20 74 68 65 |to deter|mine the|
|000036c0| 20 63 6f 6d 62 69 6e 61 | 74 69 6f 6e 20 6f 66 20 | combina|tion of |
|000036d0| 76 61 6c 75 65 73 20 74 | 68 61 74 20 77 69 6c 6c |values t|hat will|
|000036e0| 19 70 72 6f 64 75 63 65 | 20 74 68 65 20 62 65 73 |.produce| the bes|
|000036f0| 74 20 72 65 73 75 6c 74 | 73 2e 00 3d 42 65 73 74 |t result|s..=Best|
|00003700| 20 41 6e 73 77 65 72 aa | 20 77 69 6c 6c 20 2d 2d | Answer.| will --|
|00003710| 20 6d 61 6e 69 70 75 6c | 61 74 65 20 74 68 65 20 | manipul|ate the |
|00003720| 41 44 4a 55 53 54 41 42 | 4c 45 53 20 28 65 2e 67 |ADJUSTAB|LES (e.g|
|00003730| 2e 20 76 61 72 79 69 6e | 67 3d 6c 65 76 65 6c 73 |. varyin|g=levels|
|00003740| 20 6f 66 20 70 72 6f 64 | 75 63 74 69 6f 6e 29 20 | of prod|uction) |
|00003750| 77 69 74 68 69 6e 20 74 | 68 65 20 67 69 76 65 6e |within t|he given|
|00003760| 20 43 4f 4e 53 54 52 41 | 49 4e 54 53 20 28 65 2e | CONSTRA|INTS (e.|
|00003770| 67 2e 20 74 69 6d 65 3e | 6c 69 6d 69 74 73 20 6f |g. time>|limits o|
|00003780| 72 20 63 75 72 72 65 6e | 74 20 69 6e 76 65 6e 74 |r curren|t invent|
|00003790| 6f 72 79 20 6c 65 76 65 | 6c 73 29 20 74 6f 20 4f |ory leve|ls) to O|
|000037a0| 50 54 49 4d 49 5a 45 20 | 79 6f 75 72 20 4f 42 4a |PTIMIZE |your OBJ|
|000037b0| 45 43 54 49 56 45 2e 28 | 75 73 75 61 6c 6c 79 20 |ECTIVE.(|usually |
|000037c0| 74 6f 20 6d 61 78 69 6d | 69 7a 65 20 70 72 6f 66 |to maxim|ize prof|
|000037d0| 69 74 20 6f 72 20 6d 69 | 6e 69 6d 69 7a 65 20 63 |it or mi|nimize c|
|000037e0| 6f 73 74 29 2e 00 00 03 | 02 00 17 0b 59 6f 75 20 |ost)....|....You |
|000037f0| 73 69 6d 70 6c 79 3a 00 | 3e 20 20 20 31 29 20 20 |simply:.|>   1)  |
|00003800| 43 72 65 61 74 65 20 79 | 6f 75 72 20 73 70 72 65 |Create y|our spre|
|00003810| 61 64 73 68 65 65 74 20 | 69 6e 20 45 78 63 65 6c |adsheet |in Excel|
|00003820| 20 28 6c 69 6b 65 20 79 | 6f 75 20 75 73 75 61 6c | (like y|ou usual|
|00003830| 6c 79 20 64 6f 29 2e 00 | 2c 20 20 20 32 29 20 20 |ly do)..|,   2)  |
|00003840| 53 61 76 65 20 79 6f 75 | 72 20 73 70 72 65 61 64 |Save you|r spread|
|00003850| 73 68 65 65 74 20 61 73 | 20 61 20 53 59 4c 4b 20 |sheet as| a SYLK |
|00003860| 66 69 6c 65 2e 00 2e 20 | 20 20 33 29 20 20 4c 6f |file... |  3)  Lo|
|00003870| 61 64 20 74 68 65 20 73 | 70 72 65 61 64 73 68 65 |ad the s|preadshe|
|00003880| 65 74 20 69 6e 74 6f 20 | 42 65 73 74 20 41 6e 73 |et into |Best Ans|
|00003890| 77 65 72 aa 2e 00 3a 20 | 20 20 34 29 20 20 53 65 |wer...: |  4)  Se|
|000038a0| 74 20 75 70 20 74 68 65 | 20 70 72 6f 62 6c 65 6d |t up the| problem|
|000038b0| 20 66 6f 72 20 42 65 73 | 74 20 41 6e 73 77 65 72 | for Bes|t Answer|
|000038c0| aa 20 62 79 20 64 65 66 | 69 6e 69 6e 67 20 74 68 |. by def|ining th|
|000038d0| 65 42 20 20 20 20 20 20 | 20 20 20 20 61 70 70 72 |eB      |    appr|
|000038e0| 6f 70 72 69 61 74 65 20 | 63 65 6c 6c 73 3a 20 20 |opriate |cells:  |
|000038f0| 41 44 4a 55 53 54 41 42 | 4c 45 20 63 65 6c 6c 73 |ADJUSTAB|LE cells|
|00003900| 2c 20 43 4f 4e 53 54 52 | 41 49 4e 54 20 63 65 6c |, CONSTR|AINT cel|
|00003910| 6c 73 2c 20 21 20 20 20 | 20 20 20 20 20 20 20 61 |ls, !   |       a|
|00003920| 6e 64 20 74 68 65 20 4f | 42 4a 45 43 54 49 56 45 |nd the O|BJECTIVE|
|00003930| 20 63 65 6c 6c 2e 05 20 | 20 20 20 20 3d 20 20 20 | cell.. |    =   |
|00003940| 35 29 20 20 4f 50 54 49 | 4d 49 5a 45 20 28 65 69 |5)  OPTI|MIZE (ei|
|00003950| 74 68 65 72 20 6d 61 78 | 69 6d 69 7a 65 20 6f 72 |ther max|imize or|
|00003960| 20 6d 69 6e 69 6d 69 7a | 65 29 20 79 6f 75 72 20 | minimiz|e) your |
|00003970| 4f 42 4a 45 43 54 49 56 | 45 2e 00 44 20 20 20 36 |OBJECTIV|E..D   6|
|00003980| 29 20 20 53 61 76 65 20 | 74 68 65 20 6f 70 74 69 |)  Save |the opti|
|00003990| 6d 69 7a 65 64 20 73 70 | 72 65 61 64 73 68 65 65 |mized sp|readshee|
|000039a0| 74 20 66 6f 72 20 6c 61 | 74 65 72 20 75 73 65 20 |t for la|ter use |
|000039b0| 6f 72 20 66 6f 72 20 70 | 72 69 6e 74 69 6e 67 2e |or for p|rinting.|
|000039c0| 00 42 54 68 69 73 20 69 | 73 20 61 6c 6c 20 71 75 |.BThis i|s all qu|
|000039d0| 69 74 65 20 73 69 6d 70 | 6c 65 2e 20 20 20 59 6f |ite simp|le.   Yo|
|000039e0| 75 20 63 61 6e 20 66 69 | 6e 64 20 6f 75 74 20 69 |u can fi|nd out i|
|000039f0| 6e 20 6d 6f 72 65 20 64 | 65 74 61 69 6c 20 68 6f |n more d|etail ho|
|00003a00| 77 20 74 6f 41 70 65 72 | 66 6f 72 6d 20 65 61 63 |w toAper|form eac|
|00003a10| 68 20 74 61 73 6b 20 62 | 79 20 72 65 66 65 72 72 |h task b|y referr|
|00003a20| 69 6e 67 20 74 6f 20 74 | 68 65 20 42 41 53 49 43 |ing to t|he BASIC|
|00003a30| 20 54 4f 50 49 43 53 20 | 73 65 63 74 69 6f 6e 20 | TOPICS |section |
|00003a40| 6f 6e 20 74 68 65 10 48 | 45 4c 50 20 6d 65 6e 75 |on the.H|ELP menu|
|00003a50| 2e 20 20 20 20 20 20 00 | 3f 4e 4f 57 20 2d 2d 20 |.      .|?NOW -- |
|00003a60| 52 65 61 64 20 6f 6e 20 | 74 6f 20 66 61 6d 69 6c |Read on |to famil|
|00003a70| 69 7a 65 20 79 6f 75 72 | 73 65 6c 66 20 77 69 74 |ize your|self wit|
|00003a80| 68 20 61 20 66 65 77 20 | 6e 65 77 20 64 65 66 69 |h a few |new defi|
|00003a90| 6e 69 74 69 6f 6e 73 3a | 35 20 20 20 20 20 20 20 |nitions:|5       |
|00003aa0| 20 20 20 20 20 20 20 41 | 44 4a 55 53 54 41 42 4c |       A|DJUSTABL|
|00003ab0| 45 53 2c 20 43 4f 4e 53 | 54 52 41 49 4e 54 53 2c |ES, CONS|TRAINTS,|
|00003ac0| 20 4f 42 4a 45 43 54 49 | 56 45 20 61 6e 64 1c 20 | OBJECTI|VE and. |
|00003ad0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 4f 50 54 |        |     OPT|
|00003ae0| 49 4d 49 5a 41 54 49 4f | 4e 2e 20 00 00 0d b5 00 |IMIZATIO|N. .....|
|00003af0| 5c 3b 41 44 4a 55 53 54 | 41 42 4c 45 20 63 65 6c |\;ADJUST|ABLE cel|
|00003b00| 6c 73 20 2d 2d 20 54 68 | 65 20 41 44 4a 55 53 54 |ls -- Th|e ADJUST|
|00003b10| 41 42 4c 45 20 63 65 6c | 6c 73 20 61 72 65 20 74 |ABLE cel|ls are t|
|00003b20| 68 65 20 63 65 6c 6c 73 | 20 74 68 61 74 42 63 6f |he cells| thatBco|
|00003b30| 6e 74 61 69 6e 20 74 68 | 65 20 76 61 72 69 61 62 |ntain th|e variab|
|00003b40| 6c 65 73 20 6f 66 20 74 | 68 65 20 6d 6f 64 65 6c |les of t|he model|
|00003b50| 2e 20 20 54 68 65 73 65 | 20 61 72 65 20 74 68 65 |.  These| are the|
|00003b60| 20 63 65 6c 6c 73 20 79 | 6f 75 20 77 6f 75 6c 64 | cells y|ou would|
|00003b70| 3f 6d 61 6e 69 70 75 6c | 61 74 65 20 69 66 20 79 |?manipul|ate if y|
|00003b80| 6f 75 20 77 65 72 65 20 | 61 74 74 65 6d 70 74 69 |ou were |attempti|
|00003b90| 6e 67 20 74 6f 20 72 65 | 61 63 68 20 74 68 65 20 |ng to re|ach the |
|00003ba0| 6f 70 74 69 6d 61 6c 20 | 73 6f 6c 75 74 69 6f 6e |optimal |solution|
|00003bb0| 43 74 68 72 6f 75 67 68 | 20 22 57 68 61 74 20 69 |Cthrough| "What i|
|00003bc0| 66 2e 2e 2e 22 2e 20 20 | 42 65 73 74 20 41 6e 73 |f...".  |Best Ans|
|00003bd0| 77 65 72 aa 20 63 61 6c | 63 75 6c 61 74 65 73 20 |wer. cal|culates |
|00003be0| 74 68 65 73 65 20 76 61 | 72 69 61 62 6c 65 73 20 |these va|riables |
|00003bf0| 28 74 68 65 3e 76 61 6c | 75 65 73 20 6f 66 20 74 |(the>val|ues of t|
|00003c00| 68 65 20 41 44 4a 55 53 | 54 41 42 4c 45 53 29 20 |he ADJUS|TABLES) |
|00003c10| 77 68 65 6e 20 79 6f 75 | 20 4f 50 54 49 4d 49 5a |when you| OPTIMIZ|
|00003c20| 45 20 79 6f 75 72 20 73 | 70 72 65 61 64 73 68 65 |E your s|preadshe|
|00003c30| 65 74 2e 00 3d 59 6f 75 | 20 63 61 6e 20 64 65 66 |et..=You| can def|
|00003c40| 69 6e 65 20 75 70 20 74 | 6f 20 32 35 30 20 41 44 |ine up t|o 250 AD|
|00003c50| 4a 55 53 54 41 42 4c 45 | 20 63 65 6c 6c 73 20 28 |JUSTABLE| cells (|
|00003c60| 35 20 41 44 4a 55 53 54 | 41 42 4c 45 20 63 65 6c |5 ADJUST|ABLE cel|
|00003c70| 6c 73 40 69 6e 20 74 68 | 65 20 64 65 6d 6f 20 76 |ls@in th|e demo v|
|00003c80| 65 72 73 69 6f 6e 29 2e | 20 20 41 6c 6c 20 41 44 |ersion).|  All AD|
|00003c90| 4a 55 53 54 41 42 4c 45 | 20 63 65 6c 6c 73 20 6d |JUSTABLE| cells m|
|00003ca0| 75 73 74 20 63 6f 6e 74 | 61 69 6e 20 6e 75 6d 65 |ust cont|ain nume|
|00003cb0| 72 69 63 2e 76 61 6c 75 | 65 73 3b 20 74 68 65 79 |ric.valu|es; they|
|00003cc0| 20 6d 61 79 20 6e 6f 74 | 20 63 6f 6e 74 61 69 6e | may not| contain|
|00003cd0| 20 66 6f 72 6d 75 6c 61 | 73 20 6f 72 20 74 65 78 | formula|s or tex|
|00003ce0| 74 2e 00 2e 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |t...____|________|
|00003cf0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003d00| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003d10| 5f 5f 1b 54 6f 20 64 65 | 66 69 6e 65 20 41 44 4a |__.To de|fine ADJ|
|00003d20| 55 53 54 41 42 4c 45 20 | 63 65 6c 6c 73 3a 00 42 |USTABLE |cells:.B|
|00003d30| 20 20 20 31 29 20 20 53 | 65 6c 65 63 74 20 74 68 |   1)  S|elect th|
|00003d40| 65 20 61 70 70 72 6f 70 | 72 69 61 74 65 20 63 65 |e approp|riate ce|
|00003d50| 6c 6c 73 20 28 6a 75 73 | 74 20 6c 69 6b 65 20 79 |lls (jus|t like y|
|00003d60| 6f 75 20 73 65 6c 65 63 | 74 20 63 65 6c 6c 73 20 |ou selec|t cells |
|00003d70| 69 6e 11 20 20 20 20 20 | 20 20 20 20 20 45 78 63 |in.     |     Exc|
|00003d80| 65 6c 29 2e 00 36 20 20 | 20 32 29 20 20 43 68 6f |el)..6  | 2)  Cho|
|00003d90| 6f 73 65 20 22 44 65 66 | 69 6e 65 20 41 64 6a 75 |ose "Def|ine Adju|
|00003da0| 73 74 61 62 6c 65 73 22 | 20 66 72 6f 6d 20 74 68 |stables"| from th|
|00003db0| 65 20 43 65 6c 6c 20 6d | 65 6e 75 2e 2e 5f 5f 5f |e Cell m|enu..___|
|00003dc0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003dd0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003de0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 00 00 3e 43 4f |________|___..>CO|
|00003df0| 4e 53 54 52 41 49 4e 54 | 20 63 65 6c 6c 73 20 2d |NSTRAINT| cells -|
|00003e00| 2d 20 54 68 65 73 65 20 | 61 72 65 20 74 68 65 20 |- These |are the |
|00003e10| 63 65 6c 6c 73 20 74 68 | 61 74 20 63 6f 6e 74 61 |cells th|at conta|
|00003e20| 69 6e 20 61 20 66 6f 72 | 6d 75 6c 61 3f 72 65 70 |in a for|mula?rep|
|00003e30| 72 65 73 65 6e 74 69 6e | 67 20 73 6f 6d 65 20 6b |resentin|g some k|
|00003e40| 69 6e 64 20 6f 66 20 72 | 65 73 74 72 69 63 74 69 |ind of r|estricti|
|00003e50| 6e 67 20 63 6f 6e 64 69 | 74 69 6f 6e 2e 20 20 54 |ng condi|tion.  T|
|00003e60| 68 69 73 20 6d 69 67 68 | 74 20 62 65 3d 69 6e 76 |his migh|t be=inv|
|00003e70| 65 6e 74 6f 72 79 20 28 | 79 6f 75 20 63 61 6e 6e |entory (|you cann|
|00003e80| 6f 74 20 75 73 65 20 6d | 6f 72 65 20 69 6e 76 65 |ot use m|ore inve|
|00003e90| 6e 74 6f 72 79 20 74 68 | 61 6e 20 79 6f 75 20 68 |ntory th|an you h|
|00003ea0| 61 76 65 29 2c 20 74 69 | 6d 65 3f 28 79 6f 75 20 |ave), ti|me?(you |
|00003eb0| 63 61 6e 6e 6f 74 20 72 | 75 6e 20 79 6f 75 72 20 |cannot r|un your |
|00003ec0| 70 72 6f 64 75 63 74 69 | 6f 6e 20 6d 6f 72 65 20 |producti|on more |
|00003ed0| 74 68 61 6e 20 32 34 20 | 68 6f 75 72 73 20 70 65 |than 24 |hours pe|
|00003ee0| 72 20 64 61 79 29 2c 20 | 6f 72 3d 6d 6f 6e 65 79 |r day), |or=money|
|00003ef0| 20 28 79 6f 75 20 63 61 | 6e 6e 6f 74 20 75 73 65 | (you ca|nnot use|
|00003f00| 20 6d 6f 72 65 20 6d 6f | 6e 65 79 20 74 68 61 6e | more mo|ney than|
|00003f10| 20 79 6f 75 20 68 61 76 | 65 20 69 6e 20 74 68 65 | you hav|e in the|
|00003f20| 20 6b 69 74 74 79 29 2e | 00 3b 42 65 73 74 20 41 | kitty).|.;Best A|
|00003f30| 6e 73 77 65 72 aa 20 65 | 78 70 65 63 74 73 20 43 |nswer. e|xpects C|
|00003f40| 4f 4e 53 54 52 41 49 4e | 54 20 63 65 6c 6c 73 20 |ONSTRAIN|T cells |
|00003f50| 74 6f 20 62 65 20 6c 69 | 6e 65 61 72 20 66 6f 72 |to be li|near for|
|00003f60| 6d 75 6c 61 73 3b 77 68 | 6f 73 65 20 76 61 6c 75 |mulas;wh|ose valu|
|00003f70| 65 73 20 61 72 65 20 70 | 6f 73 69 74 69 76 65 20 |es are p|ositive |
|00003f80| 77 68 65 6e 20 74 68 65 | 20 72 65 73 74 72 69 63 |when the| restric|
|00003f90| 74 69 6f 6e 73 20 61 72 | 65 20 6d 65 74 20 61 6e |tions ar|e met an|
|00003fa0| 64 2b 6e 65 67 61 74 69 | 76 65 20 77 68 65 6e 20 |d+negati|ve when |
|00003fb0| 74 68 65 20 72 65 73 74 | 72 69 63 74 69 6f 6e 73 |the rest|rictions|
|00003fc0| 20 61 72 65 20 62 72 6f | 6b 65 6e 2e 20 00 41 46 | are bro|ken. .AF|
|00003fd0| 6f 72 20 65 78 61 6d 70 | 6c 65 2c 20 69 66 20 79 |or examp|le, if y|
|00003fe0| 6f 75 20 68 61 76 65 20 | 61 6e 20 22 69 6e 76 65 |ou have |an "inve|
|00003ff0| 6e 74 6f 72 79 20 69 6e | 20 73 74 6f 63 6b 22 20 |ntory in| stock" |
|00004000| 63 65 6c 6c 20 28 42 33 | 29 20 61 6e 64 20 61 6e |cell (B3|) and an|
|00004010| 41 22 69 6e 76 65 6e 74 | 6f 72 79 20 75 73 65 64 |A"invent|ory used|
|00004020| 22 20 63 65 6c 6c 20 28 | 42 34 29 2c 20 61 6e 64 |" cell (|B4), and|
|00004030| 20 79 6f 75 20 77 61 6e | 74 20 74 6f 20 6d 61 6b | you wan|t to mak|
|00004040| 65 20 73 75 72 65 20 74 | 68 61 74 20 69 6e 76 65 |e sure t|hat inve|
|00004050| 6e 2d 44 74 6f 72 79 20 | 75 73 65 64 20 69 73 20 |n-Dtory |used is |
|00004060| 6c 65 73 73 20 74 68 61 | 6e 20 28 6f 72 20 65 71 |less tha|n (or eq|
|00004070| 75 61 6c 20 74 6f 29 20 | 22 69 6e 76 65 6e 74 6f |ual to) |"invento|
|00004080| 72 79 20 69 6e 20 73 74 | 6f 63 6b 22 2c 20 79 6f |ry in st|ock", yo|
|00004090| 75 20 77 6f 75 6c 64 36 | 63 72 65 61 74 65 20 61 |u would6|create a|
|000040a0| 20 6e 65 77 20 63 65 6c | 6c 20 69 6e 20 74 68 65 | new cel|l in the|
|000040b0| 20 73 70 72 65 61 64 73 | 68 65 65 74 20 77 69 74 | spreads|heet wit|
|000040c0| 68 20 74 68 65 20 66 6f | 72 6d 75 6c 61 3a 00 0b |h the fo|rmula:..|
|000040d0| 20 20 20 20 20 3d 42 33 | 2d 42 34 05 20 20 20 20 |     =B3|-B4.    |
|000040e0| 20 3f 54 68 69 73 20 69 | 73 20 74 68 65 20 63 65 | ?This i|s the ce|
|000040f0| 6c 6c 20 74 68 61 74 20 | 79 6f 75 20 77 69 6c 6c |ll that |you will|
|00004100| 20 64 65 66 69 6e 65 20 | 61 73 20 61 20 43 4f 4e | define |as a CON|
|00004110| 53 54 52 41 49 4e 54 20 | 63 65 6c 6c 3b 20 20 69 |STRAINT |cell;  i|
|00004120| 74 15 63 61 6e 6e 6f 74 | 20 67 6f 20 62 65 6c 6f |t.cannot| go belo|
|00004130| 77 20 7a 65 72 6f 2e 00 | 3b 57 68 65 6e 20 79 6f |w zero..|;When yo|
|00004140| 75 20 4f 50 54 49 4d 49 | 5a 45 2c 20 42 65 73 74 |u OPTIMI|ZE, Best|
|00004150| 20 41 6e 73 77 65 72 aa | 20 77 69 6c 6c 20 6e 6f | Answer.| will no|
|00004160| 74 20 76 69 6f 6c 61 74 | 65 20 61 6e 79 20 6f 66 |t violat|e any of|
|00004170| 20 74 68 65 15 64 65 66 | 69 6e 65 64 20 72 65 73 | the.def|ined res|
|00004180| 74 72 69 63 74 69 6f 6e | 73 2e 00 3e 4e 6f 74 65 |triction|s..>Note|
|00004190| 3a 20 20 59 6f 75 20 73 | 65 74 20 75 70 20 43 4f |:  You s|et up CO|
|000041a0| 4e 53 54 52 41 49 4e 54 | 20 63 65 6c 6c 73 20 66 |NSTRAINT| cells f|
|000041b0| 72 6f 6d 20 77 69 74 68 | 69 6e 20 45 78 63 65 6c |rom with|in Excel|
|000041c0| 2e 20 20 59 6f 75 20 63 | 61 6e 3f 20 20 20 20 20 |.  You c|an?     |
|000041d0| 20 20 20 20 20 20 72 65 | 61 64 20 6d 6f 72 65 20 |      re|ad more |
|000041e0| 61 62 6f 75 74 20 68 6f | 77 20 74 6f 20 64 6f 20 |about ho|w to do |
|000041f0| 74 68 69 73 20 62 79 20 | 72 65 66 65 72 72 69 6e |this by |referrin|
|00004200| 67 20 74 6f 20 22 4d 6f | 72 65 34 20 20 20 20 20 |g to "Mo|re4     |
|00004210| 20 20 20 20 20 20 41 62 | 6f 75 74 20 43 6f 6e 73 |      Ab|out Cons|
|00004220| 74 72 61 69 6e 74 20 43 | 65 6c 6c 73 22 20 6f 6e |traint C|ells" on|
|00004230| 20 74 68 65 20 48 45 4c | 50 20 6d 65 6e 75 2e 00 | the HEL|P menu..|
|00004240| 2e 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |._______|________|
|00004250| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004260| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 1b |________|_______.|
|00004270| 54 6f 20 64 65 66 69 6e | 65 20 43 4f 4e 53 54 52 |To defin|e CONSTR|
|00004280| 41 49 4e 54 20 63 65 6c | 6c 73 3a 00 3f 20 20 20 |AINT cel|ls:.?   |
|00004290| 31 29 20 20 53 65 6c 65 | 63 74 20 74 68 65 20 63 |1)  Sele|ct the c|
|000042a0| 65 6c 6c 73 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |ells you| want to|
|000042b0| 20 64 65 66 69 6e 65 20 | 61 73 20 43 4f 4e 53 54 | define |as CONST|
|000042c0| 52 41 49 4e 54 20 63 65 | 6c 6c 73 2e 41 20 20 20 |RAINT ce|lls.A   |
|000042d0| 20 20 20 20 20 20 20 59 | 6f 75 20 6d 61 79 20 64 |       Y|ou may d|
|000042e0| 65 66 69 6e 65 20 75 70 | 20 74 6f 20 32 35 30 20 |efine up| to 250 |
|000042f0| 43 4f 4e 53 54 52 41 49 | 4e 54 20 63 65 6c 6c 73 |CONSTRAI|NT cells|
|00004300| 20 28 38 20 43 4f 4e 53 | 54 52 41 49 4e 54 25 20 | (8 CONS|TRAINT% |
|00004310| 20 20 20 20 20 20 20 20 | 20 63 65 6c 6c 73 20 69 |        | cells i|
|00004320| 6e 20 74 68 65 20 64 65 | 6d 6f 20 76 65 72 73 69 |n the de|mo versi|
|00004330| 6f 6e 29 2e 06 20 20 20 | 20 20 20 3b 20 20 20 32 |on)..   |   ;   2|
|00004340| 29 20 20 43 68 6f 6f 73 | 65 20 22 44 65 66 69 6e |)  Choos|e "Defin|
|00004350| 65 20 43 6f 6e 73 74 72 | 61 69 6e 74 73 22 20 66 |e Constr|aints" f|
|00004360| 72 6f 6d 20 74 68 65 20 | 43 65 6c 6c 20 6d 65 6e |rom the |Cell men|
|00004370| 75 2e 20 20 20 20 20 00 | 3e 52 45 4d 45 4d 42 45 |u.     .|>REMEMBE|
|00004380| 52 3a 20 20 20 41 6c 6c | 20 43 4f 4e 53 54 52 41 |R:   All| CONSTRA|
|00004390| 49 4e 54 20 63 65 6c 6c | 73 20 6d 75 73 74 20 63 |INT cell|s must c|
|000043a0| 6f 6e 74 61 69 6e 20 6c | 69 6e 65 61 72 20 66 6f |ontain l|inear fo|
|000043b0| 72 6d 75 6c 61 73 20 3a | 20 20 20 20 20 20 20 20 |rmulas :|        |
|000043c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 28 |        |       (|
|000043d0| 73 65 65 20 22 4c 69 6e | 65 61 72 69 74 79 22 20 |see "Lin|earity" |
|000043e0| 6f 6e 20 74 68 65 20 48 | 45 4c 50 20 6d 65 6e 75 |on the H|ELP menu|
|000043f0| 29 2e 2e 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |).._____|________|
|00004400| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004410| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004420| 5f 00 00 3f 4f 42 4a 45 | 43 54 49 56 45 20 63 65 |_..?OBJE|CTIVE ce|
|00004430| 6c 6c 20 2d 2d 20 54 68 | 65 20 4f 42 4a 45 43 54 |ll -- Th|e OBJECT|
|00004440| 49 56 45 20 63 65 6c 6c | 20 69 73 20 74 68 65 20 |IVE cell| is the |
|00004450| 63 65 6c 6c 20 74 68 61 | 74 20 63 6f 6e 74 61 69 |cell tha|t contai|
|00004460| 6e 73 20 41 74 68 65 20 | 76 61 6c 75 65 20 74 68 |ns Athe |value th|
|00004470| 61 74 20 79 6f 75 20 77 | 6f 75 6c 64 20 6c 69 6b |at you w|ould lik|
|00004480| 65 20 74 6f 20 4f 50 54 | 49 4d 49 5a 45 20 28 6d |e to OPT|IMIZE (m|
|00004490| 61 78 69 6d 69 7a 65 20 | 6f 72 20 6d 69 6e 69 6d |aximize |or minim|
|000044a0| 69 7a 65 29 2e 3f 54 79 | 70 69 63 61 6c 20 65 78 |ize).?Ty|pical ex|
|000044b0| 61 6d 70 6c 65 73 20 6f | 66 20 4f 42 4a 45 43 54 |amples o|f OBJECT|
|000044c0| 49 56 45 20 63 65 6c 6c | 73 20 61 72 65 20 70 72 |IVE cell|s are pr|
|000044d0| 6f 66 69 74 20 63 65 6c | 6c 73 20 28 66 6f 72 20 |ofit cel|ls (for |
|000044e0| 6d 61 78 69 2d 3e 6d 69 | 7a 61 74 69 6f 6e 29 20 |maxi->mi|zation) |
|000044f0| 6f 72 20 63 6f 73 74 20 | 63 65 6c 6c 73 20 28 66 |or cost |cells (f|
|00004500| 6f 72 20 6d 69 6e 69 6d | 69 7a 61 74 69 6f 6e 29 |or minim|ization)|
|00004510| 2e 20 20 42 65 73 74 20 | 41 6e 73 77 65 72 aa 20 |.  Best |Answer. |
|00004520| 77 69 6c 6c 3e 64 65 74 | 65 72 6d 69 6e 65 20 74 |will>det|ermine t|
|00004530| 68 65 20 63 6f 6d 62 69 | 6e 61 74 69 6f 6e 20 6f |he combi|nation o|
|00004540| 66 20 41 44 4a 55 53 54 | 41 42 4c 45 20 63 65 6c |f ADJUST|ABLE cel|
|00004550| 6c 20 76 61 6c 75 65 73 | 20 74 68 61 74 20 79 69 |l values| that yi|
|00004560| 65 6c 64 44 74 68 65 20 | 62 65 73 74 20 70 6f 73 |eldDthe |best pos|
|00004570| 73 69 62 6c 65 20 61 6e | 73 77 65 72 20 66 6f 72 |sible an|swer for|
|00004580| 20 74 68 65 20 4f 42 4a | 45 43 54 49 56 45 20 63 | the OBJ|ECTIVE c|
|00004590| 65 6c 6c 2c 20 62 75 74 | 20 64 6f 65 73 20 6e 6f |ell, but| does no|
|000045a0| 74 20 61 6c 6c 6f 77 20 | 34 74 68 65 20 76 61 6c |t allow |4the val|
|000045b0| 75 65 20 6f 66 20 61 6e | 79 20 43 4f 4e 53 54 52 |ue of an|y CONSTR|
|000045c0| 41 49 4e 54 20 63 65 6c | 6c 20 74 6f 20 62 65 63 |AINT cel|l to bec|
|000045d0| 6f 6d 65 20 6e 65 67 61 | 74 69 76 65 2e 00 2e 5f |ome nega|tive..._|
|000045e0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000045f0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004600| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 1d 54 6f |________|_____.To|
|00004610| 20 64 65 66 69 6e 65 20 | 74 68 65 20 4f 42 4a 45 | define |the OBJE|
|00004620| 43 54 49 56 45 20 63 65 | 6c 6c 3a 00 40 20 20 20 |CTIVE ce|ll:.@   |
|00004630| 31 29 20 20 53 65 6c 65 | 63 74 20 74 68 65 20 63 |1)  Sele|ct the c|
|00004640| 65 6c 6c 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 |ell you |want to |
|00004650| 64 65 66 69 6e 65 20 61 | 73 20 74 68 65 20 4f 42 |define a|s the OB|
|00004660| 4a 45 43 54 49 56 45 20 | 63 65 6c 6c 2e 00 34 20 |JECTIVE |cell..4 |
|00004670| 20 20 32 29 20 20 43 68 | 6f 6f 73 65 20 22 44 65 |  2)  Ch|oose "De|
|00004680| 66 69 6e 65 20 4f 62 6a | 65 63 74 69 76 65 22 20 |fine Obj|ective" |
|00004690| 66 72 6f 6d 20 74 68 65 | 20 43 65 6c 6c 20 6d 65 |from the| Cell me|
|000046a0| 6e 75 2e 00 39 52 45 4d | 45 4d 42 45 52 3a 20 20 |nu..9REM|EMBER:  |
|000046b0| 59 6f 75 72 20 4f 42 4a | 45 43 54 49 56 45 20 63 |Your OBJ|ECTIVE c|
|000046c0| 65 6c 6c 20 6d 75 73 74 | 20 62 65 20 61 20 6c 69 |ell must| be a li|
|000046d0| 6e 65 61 72 20 66 6f 72 | 6d 75 6c 61 2e 20 39 20 |near for|mula. 9 |
|000046e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000046f0| 20 20 20 20 20 28 73 65 | 65 20 22 4c 69 6e 65 61 |     (se|e "Linea|
|00004700| 72 69 74 79 22 20 6f 6e | 20 74 68 65 20 48 45 4c |rity" on| the HEL|
|00004710| 50 20 6d 65 6e 75 29 2e | 2e 5f 5f 5f 5f 5f 5f 5f |P menu).|._______|
|00004720| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004730| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004740| 5f 5f 5f 5f 5f 5f 5f 00 | 00 27 4f 50 54 49 4d 49 |_______.|.'OPTIMI|
|00004750| 5a 41 54 49 4f 4e 20 2d | 2d 20 54 68 69 73 20 69 |ZATION -|- This i|
|00004760| 73 20 74 68 65 20 66 69 | 6e 61 6c 20 73 74 65 70 |s the fi|nal step|
|00004770| 21 00 3b 42 65 73 74 20 | 41 6e 73 77 65 72 aa 20 |!.;Best |Answer. |
|00004780| 77 69 6c 6c 20 4f 50 54 | 49 4d 49 5a 45 20 79 6f |will OPT|IMIZE yo|
|00004790| 75 72 20 4f 42 4a 45 43 | 54 49 56 45 2c 20 77 69 |ur OBJEC|TIVE, wi|
|000047a0| 74 68 69 6e 20 74 68 65 | 20 67 69 76 65 6e 3a 43 |thin the| given:C|
|000047b0| 4f 4e 53 54 52 41 49 4e | 54 53 2c 20 62 79 20 63 |ONSTRAIN|TS, by c|
|000047c0| 61 6c 63 75 6c 61 74 69 | 6e 67 20 79 6f 75 72 20 |alculati|ng your |
|000047d0| 41 44 4a 55 53 54 41 42 | 4c 45 53 20 74 6f 20 61 |ADJUSTAB|LES to a|
|000047e0| 74 74 61 69 6e 20 74 68 | 65 0e 22 42 65 73 74 20 |ttain th|e."Best |
|000047f0| 41 6e 73 77 65 72 22 2e | 00 2e 5f 5f 5f 5f 5f 5f |Answer".|..______|
|00004800| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004810| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004820| 5f 5f 5f 5f 5f 5f 5f 5f | 0c 54 6f 20 4f 50 54 49 |________|.To OPTI|
|00004830| 4d 49 5a 45 3a 00 3e 20 | 20 20 43 68 6f 6f 73 65 |MIZE:.> |  Choose|
|00004840| 20 22 4d 61 78 69 6d 69 | 7a 65 22 20 6f 72 20 22 | "Maximi|ze" or "|
|00004850| 4d 69 6e 69 6d 69 7a 65 | 22 20 66 72 6f 6d 20 74 |Minimize|" from t|
|00004860| 68 65 20 4f 70 74 69 6d | 69 7a 61 74 69 6f 6e 20 |he Optim|ization |
|00004870| 6d 65 6e 75 2e 2e 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |menu..__|________|
|00004880| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004890| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000048a0| 5f 5f 5f 5f 00 00 02 96 | 00 11 3c 59 6f 75 20 73 |____....|..<You s|
|000048b0| 65 74 20 75 70 20 79 6f | 75 72 20 73 70 72 65 61 |et up yo|ur sprea|
|000048c0| 64 73 68 65 65 74 20 69 | 6e 20 45 78 63 65 6c 20 |dsheet i|n Excel |
|000048d0| 61 6e 64 20 73 61 76 65 | 20 69 74 20 69 6e 20 74 |and save| it in t|
|000048e0| 68 65 20 53 59 4c 4b 3e | 66 6f 72 6d 61 74 2e 20 |he SYLK>|format. |
|000048f0| 20 4c 6f 61 64 20 79 6f | 75 72 20 73 70 72 65 61 | Load yo|ur sprea|
|00004900| 64 73 68 65 65 74 20 69 | 6e 74 6f 20 42 65 73 74 |dsheet i|nto Best|
|00004910| 20 41 6e 73 77 65 72 aa | 2e 20 20 44 65 66 69 6e | Answer.|.  Defin|
|00004920| 65 20 74 68 65 20 37 74 | 68 72 65 65 20 74 79 70 |e the 7t|hree typ|
|00004930| 65 73 20 6f 66 20 63 65 | 6c 6c 73 3a 20 20 41 44 |es of ce|lls:  AD|
|00004940| 4a 55 53 54 41 42 4c 45 | 53 2c 20 43 4f 4e 53 54 |JUSTABLE|S, CONST|
|00004950| 52 41 49 4e 54 53 20 61 | 6e 64 20 74 68 65 39 4f |RAINTS a|nd the9O|
|00004960| 42 4a 45 43 54 49 56 45 | 20 63 65 6c 6c 2e 20 20 |BJECTIVE| cell.  |
|00004970| 53 65 6c 65 63 74 20 22 | 4d 61 78 69 6d 69 7a 65 |Select "|Maximize|
|00004980| 22 20 6f 72 20 22 4d 69 | 6e 69 6d 69 7a 65 22 20 |" or "Mi|nimize" |
|00004990| 66 72 6f 6d 20 74 68 65 | 12 4f 70 74 69 6d 69 7a |from the|.Optimiz|
|000049a0| 61 74 69 6f 6e 20 6d 65 | 6e 75 2e 00 3f 54 68 65 |ation me|nu..?The|
|000049b0| 6e 2c 20 42 65 73 74 20 | 41 6e 73 77 65 72 aa 20 |n, Best |Answer. |
|000049c0| 63 61 6c 63 75 6c 61 74 | 65 73 20 74 68 65 20 62 |calculat|es the b|
|000049d0| 65 73 74 20 70 6f 73 73 | 69 62 6c 65 20 61 6e 73 |est poss|ible ans|
|000049e0| 77 65 72 20 66 6f 72 20 | 79 6f 75 72 15 70 61 72 |wer for |your.par|
|000049f0| 74 69 63 75 6c 61 72 20 | 73 69 74 75 61 74 69 6f |ticular |situatio|
|00004a00| 6e 2e 2e 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |n.._____|________|
|00004a10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004a20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004a30| 5f 00 34 59 6f 75 20 68 | 61 76 65 20 66 69 6e 69 |_.4You h|ave fini|
|00004a40| 73 68 65 64 20 72 65 61 | 64 69 6e 67 20 74 68 65 |shed rea|ding the|
|00004a50| 20 49 4e 54 52 4f 44 55 | 43 54 49 4f 4e 20 73 65 | INTRODU|CTION se|
|00004a60| 63 74 69 6f 6e 2e 20 00 | 32 54 6f 20 66 75 72 74 |ction. .|2To furt|
|00004a70| 68 65 72 20 66 61 6d 69 | 6c 69 61 72 69 7a 65 20 |her fami|liarize |
|00004a80| 79 6f 75 72 73 65 6c 66 | 20 77 69 74 68 20 42 65 |yourself| with Be|
|00004a90| 73 74 20 41 6e 73 77 65 | 72 aa 3a 34 20 20 20 31 |st Answe|r.:4   1|
|00004aa0| 29 20 20 52 65 61 64 20 | 74 68 72 6f 75 67 68 20 |)  Read |through |
|00004ab0| 22 42 61 73 69 63 20 54 | 6f 70 69 63 73 22 20 6f |"Basic T|opics" o|
|00004ac0| 6e 20 74 68 65 20 48 45 | 4c 50 20 6d 65 6e 75 2e |n the HE|LP menu.|
|00004ad0| 2f 20 20 20 32 29 20 20 | 57 6f 72 6b 20 61 20 66 |/   2)  |Work a f|
|00004ae0| 65 77 20 6f 66 20 74 68 | 65 20 65 78 61 6d 70 6c |ew of th|e exampl|
|00004af0| 65 73 20 66 6f 72 20 70 | 72 61 63 74 69 63 65 2e |es for p|ractice.|
|00004b00| 00 3c 43 6c 69 63 6b 20 | 22 4e 65 78 74 22 20 6f |.<Click |"Next" o|
|00004b10| 72 20 73 65 6c 65 63 74 | 20 74 68 65 20 64 65 73 |r select| the des|
|00004b20| 69 72 65 64 20 74 6f 70 | 69 63 20 66 72 6f 6d 20 |ired top|ic from |
|00004b30| 74 68 65 20 48 45 4c 50 | 20 6d 65 6e 75 2e 00 00 |the HELP| menu...|
|00004b40| 00 5c 00 02 39 43 6c 69 | 63 6b 20 22 4e 65 78 74 |.\..9Cli|ck "Next|
|00004b50| 22 20 74 6f 20 70 72 6f | 63 65 65 64 2c 20 6f 72 |" to pro|ceed, or|
|00004b60| 20 73 65 6c 65 63 74 20 | 22 54 6f 70 69 63 73 22 | select |"Topics"|
|00004b70| 20 74 6f 20 73 65 65 20 | 61 20 6c 69 73 74 1f 6f | to see |a list.o|
|00004b80| 66 20 74 68 65 20 74 6f | 70 69 63 73 20 69 6e 20 |f the to|pics in |
|00004b90| 74 68 69 73 20 73 65 63 | 74 69 6f 6e 2e 20 00 00 |this sec|tion. ..|
|00004ba0| 03 da 00 18 3c 49 6e 20 | 6f 72 64 65 72 20 74 6f |....<In |order to|
|00004bb0| 20 75 73 65 20 42 65 73 | 74 20 41 6e 73 77 65 72 | use Bes|t Answer|
|00004bc0| aa 2c 20 79 6f 75 20 6d | 75 73 74 20 66 69 72 73 |., you m|ust firs|
|00004bd0| 74 20 6c 6f 61 64 20 79 | 6f 75 72 20 45 78 63 65 |t load y|our Exce|
|00004be0| 6c 40 73 70 72 65 61 64 | 73 68 65 65 74 20 69 6e |l@spread|sheet in|
|00004bf0| 74 6f 20 74 68 65 20 70 | 72 6f 67 72 61 6d 2e 20 |to the p|rogram. |
|00004c00| 20 42 65 73 74 20 41 6e | 73 77 65 72 aa 20 6f 6e | Best An|swer. on|
|00004c10| 6c 79 20 72 65 61 64 73 | 20 61 20 73 70 72 65 61 |ly reads| a sprea|
|00004c20| 64 2d 42 73 68 65 65 74 | 20 74 68 61 74 20 68 61 |d-Bsheet| that ha|
|00004c30| 73 20 62 65 65 6e 20 73 | 74 6f 72 65 64 20 69 6e |s been s|tored in|
|00004c40| 20 53 59 4c 4b 20 28 66 | 6f 72 20 22 73 79 6d 62 | SYLK (f|or "symb|
|00004c50| 6f 6c 69 63 20 6c 69 6e | 6b 22 29 20 66 6f 72 6d |olic lin|k") form|
|00004c60| 61 74 2e 20 20 00 31 49 | 6e 20 6f 72 64 65 72 20 |at.  .1I|n order |
|00004c70| 74 6f 20 73 61 76 65 20 | 79 6f 75 72 20 73 70 72 |to save |your spr|
|00004c80| 65 61 64 73 68 65 65 74 | 20 69 6e 20 53 59 4c 4b |eadsheet| in SYLK|
|00004c90| 20 66 6f 72 6d 61 74 3a | 00 43 20 20 31 29 20 20 | format:|.C  1)  |
|00004ca0| 53 61 76 65 20 74 68 65 | 20 73 70 72 65 61 64 73 |Save the| spreads|
|00004cb0| 68 65 65 74 20 66 72 6f | 6d 20 77 69 74 68 69 6e |heet fro|m within|
|00004cc0| 20 45 78 63 65 6c 20 75 | 73 69 6e 67 20 74 68 65 | Excel u|sing the|
|00004cd0| 20 22 53 61 76 65 20 41 | 73 2e 2e 2e 22 2b 20 20 | "Save A|s..."+  |
|00004ce0| 20 20 20 20 20 20 20 63 | 6f 6d 6d 61 6e 64 20 66 |       c|ommand f|
|00004cf0| 72 6f 6d 20 74 68 65 20 | 45 78 63 65 6c 20 66 69 |rom the |Excel fi|
|00004d00| 6c 65 20 6d 65 6e 75 2c | 20 00 42 20 20 32 29 20 |le menu,| .B  2) |
|00004d10| 20 57 68 65 6e 20 74 68 | 65 20 64 69 61 6c 6f 67 | When th|e dialog|
|00004d20| 20 62 6f 78 20 61 70 70 | 65 61 72 73 2c 20 73 65 | box app|ears, se|
|00004d30| 6c 65 63 74 20 74 68 65 | 20 53 59 4c 4b 20 72 61 |lect the| SYLK ra|
|00004d40| 64 69 6f 20 62 75 74 74 | 6f 6e 20 61 74 45 20 20 |dio butt|on atE  |
|00004d50| 20 20 20 20 20 20 20 74 | 68 65 20 62 6f 74 74 6f |       t|he botto|
|00004d60| 6d 2e 20 43 6c 69 63 6b | 20 74 68 65 20 22 53 61 |m. Click| the "Sa|
|00004d70| 76 65 22 20 62 75 74 74 | 6f 6e 20 61 6e 64 20 45 |ve" butt|on and E|
|00004d80| 78 63 65 6c 20 77 69 6c | 6c 20 61 75 74 6f 6d 61 |xcel wil|l automa|
|00004d90| 74 69 2d 45 20 20 20 20 | 20 20 20 20 20 63 61 6c |ti-E    |     cal|
|00004da0| 6c 79 20 73 61 76 65 20 | 79 6f 75 72 20 66 69 6c |ly save |your fil|
|00004db0| 65 20 69 6e 20 53 59 4c | 4b 20 66 6f 72 6d 61 74 |e in SYL|K format|
|00004dc0| 2c 20 20 61 6c 6c 6f 77 | 69 6e 67 20 69 74 20 74 |,  allow|ing it t|
|00004dd0| 6f 20 62 65 20 72 65 61 | 64 19 20 20 20 20 20 20 |o be rea|d.      |
|00004de0| 20 20 20 62 79 20 42 65 | 73 74 20 41 6e 73 77 65 |   by Be|st Answe|
|00004df0| 72 aa 2e 06 20 20 20 20 | 20 20 2e 5f 5f 5f 5f 5f |r...    |  ._____|
|00004e00| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004e10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004e20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 2a 54 6f 20 6c 6f 61 |________|_*To loa|
|00004e30| 64 20 74 68 65 20 73 70 | 72 65 61 64 73 68 65 65 |d the sp|readshee|
|00004e40| 74 20 69 6e 74 6f 20 42 | 65 73 74 20 41 6e 73 77 |t into B|est Answ|
|00004e50| 65 72 aa 3a 00 1d 20 20 | 20 31 29 20 20 53 74 61 |er.:..  | 1)  Sta|
|00004e60| 72 74 20 75 70 20 42 65 | 73 74 20 41 6e 73 77 65 |rt up Be|st Answe|
|00004e70| 72 aa 2e 2a 20 20 20 32 | 29 20 20 53 65 6c 65 63 |r..*   2|)  Selec|
|00004e80| 74 20 22 4f 70 65 6e 22 | 20 66 72 6f 6d 20 74 68 |t "Open"| from th|
|00004e90| 65 20 46 69 6c 65 20 4d | 65 6e 75 2e 20 20 36 20 |e File M|enu.  6 |
|00004ea0| 20 20 33 29 20 20 43 68 | 6f 6f 73 65 20 74 68 65 |  3)  Ch|oose the|
|00004eb0| 20 64 65 73 69 72 65 64 | 20 66 69 6c 65 20 66 72 | desired| file fr|
|00004ec0| 6f 6d 20 74 68 65 20 73 | 65 6c 65 63 74 69 6f 6e |om the s|election|
|00004ed0| 20 62 6f 78 2e 2e 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f | box..__|________|
|00004ee0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004ef0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004f00| 5f 5f 5f 5f 00 39 4e 6f | 74 65 3a 20 20 42 65 73 |____.9No|te:  Bes|
|00004f10| 74 20 41 6e 73 77 65 72 | aa 20 69 73 20 63 6f 6d |t Answer|. is com|
|00004f20| 70 61 74 69 62 6c 65 20 | 77 69 74 68 20 53 59 4c |patible |with SYL|
|00004f30| 4b 20 66 6f 72 6d 61 74 | 20 66 69 6c 65 73 20 3c |K format| files <|
|00004f40| 20 20 20 20 20 20 20 20 | 20 20 20 63 72 65 61 74 |        |   creat|
|00004f50| 65 64 20 62 79 20 4d 69 | 63 72 6f 73 6f 66 74 a8 |ed by Mi|crosoft.|
|00004f60| 20 45 78 63 65 6c 2c 20 | 4d 75 6c 74 69 70 6c 61 | Excel, |Multipla|
|00004f70| 6e 20 6f 72 20 57 6f 72 | 6b 73 2e 20 00 00 01 d9 |n or Wor|ks. ....|
|00004f80| 00 0c 1b 54 6f 20 64 65 | 66 69 6e 65 20 41 44 4a |...To de|fine ADJ|
|00004f90| 55 53 54 41 42 4c 45 20 | 63 65 6c 6c 73 3a 00 42 |USTABLE |cells:.B|
|00004fa0| 20 20 20 31 29 20 20 53 | 65 6c 65 63 74 20 74 68 |   1)  S|elect th|
|00004fb0| 65 20 61 70 70 72 6f 70 | 72 69 61 74 65 20 63 65 |e approp|riate ce|
|00004fc0| 6c 6c 73 20 28 6a 75 73 | 74 20 6c 69 6b 65 20 79 |lls (jus|t like y|
|00004fd0| 6f 75 20 73 65 6c 65 63 | 74 20 63 65 6c 6c 73 20 |ou selec|t cells |
|00004fe0| 69 6e 11 20 20 20 20 20 | 20 20 20 20 20 45 78 63 |in.     |     Exc|
|00004ff0| 65 6c 29 2e 00 36 20 20 | 20 32 29 20 20 43 68 6f |el)..6  | 2)  Cho|
|00005000| 6f 73 65 20 22 44 65 66 | 69 6e 65 20 41 64 6a 75 |ose "Def|ine Adju|
|00005010| 73 74 61 62 6c 65 73 22 | 20 66 72 6f 6d 20 74 68 |stables"| from th|
|00005020| 65 20 43 65 6c 6c 20 6d | 65 6e 75 2e 00 3d 59 6f |e Cell m|enu..=Yo|
|00005030| 75 20 63 61 6e 20 64 65 | 66 69 6e 65 20 75 70 20 |u can de|fine up |
|00005040| 74 6f 20 32 35 30 20 41 | 44 4a 55 53 54 41 42 4c |to 250 A|DJUSTABL|
|00005050| 45 20 63 65 6c 6c 73 20 | 28 35 20 41 44 4a 55 53 |E cells |(5 ADJUS|
|00005060| 54 41 42 4c 45 20 63 65 | 6c 6c 73 40 69 6e 20 74 |TABLE ce|lls@in t|
|00005070| 68 65 20 64 65 6d 6f 20 | 76 65 72 73 69 6f 6e 29 |he demo |version)|
|00005080| 2e 20 20 41 6c 6c 20 41 | 44 4a 55 53 54 41 42 4c |.  All A|DJUSTABL|
|00005090| 45 20 63 65 6c 6c 73 20 | 6d 75 73 74 20 63 6f 6e |E cells |must con|
|000050a0| 74 61 69 6e 20 6e 75 6d | 65 72 69 63 40 76 61 6c |tain num|eric@val|
|000050b0| 75 65 73 3b 20 74 68 65 | 79 20 6d 61 79 20 6e 6f |ues; the|y may no|
|000050c0| 74 20 63 6f 6e 74 61 69 | 6e 20 66 6f 72 6d 75 6c |t contai|n formul|
|000050d0| 61 73 20 6f 72 20 74 65 | 78 74 2e 20 20 45 61 63 |as or te|xt.  Eac|
|000050e0| 68 20 20 41 44 4a 55 53 | 54 41 42 4c 45 41 63 65 |h  ADJUS|TABLEAce|
|000050f0| 6c 6c 20 6d 75 73 74 20 | 62 65 20 72 65 66 65 72 |ll must |be refer|
|00005100| 65 6e 63 65 64 20 62 79 | 20 61 74 20 6c 65 61 73 |enced by| at leas|
|00005110| 74 20 6f 6e 65 20 63 6f | 6e 73 74 72 61 69 6e 74 |t one co|nstraint|
|00005120| 20 66 6f 72 6d 75 6c 61 | 20 6f 72 20 74 68 65 29 | formula| or the)|
|00005130| 6d 6f 64 65 6c 20 77 69 | 6c 6c 20 62 65 20 63 6f |model wi|ll be co|
|00005140| 6e 73 69 64 65 72 65 64 | 20 22 75 6e 63 6f 6e 73 |nsidered| "uncons|
|00005150| 74 72 61 69 6e 65 64 22 | 2e 00 00 01 80 00 0a 1b |trained"|........|
|00005160| 54 6f 20 64 65 66 69 6e | 65 20 43 4f 4e 53 54 52 |To defin|e CONSTR|
|00005170| 41 49 4e 54 20 63 65 6c | 6c 73 3a 00 3e 20 20 20 |AINT cel|ls:.>   |
|00005180| 31 29 20 20 53 65 6c 65 | 63 74 20 74 68 65 20 63 |1)  Sele|ct the c|
|00005190| 65 6c 6c 73 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |ells you| want to|
|000051a0| 20 64 65 66 69 6e 65 20 | 61 73 20 43 4f 4e 53 54 | define |as CONST|
|000051b0| 52 41 49 4e 54 20 63 65 | 6c 6c 73 40 20 20 20 20 |RAINT ce|lls@    |
|000051c0| 20 20 20 20 20 59 6f 75 | 20 6d 61 79 20 64 65 66 |     You| may def|
|000051d0| 69 6e 65 20 75 70 20 74 | 6f 20 32 35 30 20 43 4f |ine up t|o 250 CO|
|000051e0| 4e 53 54 52 41 49 4e 54 | 20 63 65 6c 6c 73 20 28 |NSTRAINT| cells (|
|000051f0| 38 20 43 4f 4e 53 54 52 | 41 49 4e 54 24 20 20 20 |8 CONSTR|AINT$   |
|00005200| 20 20 20 20 20 20 63 65 | 6c 6c 73 20 69 6e 20 74 |      ce|lls in t|
|00005210| 68 65 20 64 65 6d 6f 20 | 76 65 72 73 69 6f 6e 29 |he demo |version)|
|00005220| 2e 06 20 20 20 20 20 20 | 3b 20 20 20 32 29 20 20 |..      |;   2)  |
|00005230| 43 68 6f 6f 73 65 20 22 | 44 65 66 69 6e 65 20 43 |Choose "|Define C|
|00005240| 6f 6e 73 74 72 61 69 6e | 74 73 22 20 66 72 6f 6d |onstrain|ts" from|
|00005250| 20 74 68 65 20 43 65 6c | 6c 20 6d 65 6e 75 2e 20 | the Cel|l menu. |
|00005260| 20 20 20 20 00 3d 52 45 | 4d 45 4d 42 45 52 3a 20 |    .=RE|MEMBER: |
|00005270| 20 41 6c 6c 20 43 4f 4e | 53 54 52 41 49 4e 54 20 | All CON|STRAINT |
|00005280| 63 65 6c 6c 73 20 6d 75 | 73 74 20 63 6f 6e 74 61 |cells mu|st conta|
|00005290| 69 6e 20 6c 69 6e 65 61 | 72 20 66 6f 72 6d 75 6c |in linea|r formul|
|000052a0| 61 73 20 39 20 20 20 20 | 20 20 20 20 20 20 20 20 |as 9    |        |
|000052b0| 20 20 20 20 20 20 20 20 | 20 20 28 73 65 65 20 22 |        |  (see "|
|000052c0| 4c 69 6e 65 61 72 69 74 | 79 22 20 6f 6e 20 74 68 |Linearit|y" on th|
|000052d0| 65 20 48 45 4c 50 20 6d | 65 6e 75 29 2e 00 00 01 |e HELP m|enu)....|
|000052e0| 12 00 08 1d 54 6f 20 64 | 65 66 69 6e 65 20 74 68 |....To d|efine th|
|000052f0| 65 20 4f 42 4a 45 43 54 | 49 56 45 20 63 65 6c 6c |e OBJECT|IVE cell|
|00005300| 3a 00 40 20 20 20 31 29 | 20 20 53 65 6c 65 63 74 |:.@   1)|  Select|
|00005310| 20 74 68 65 20 63 65 6c | 6c 20 79 6f 75 20 77 61 | the cel|l you wa|
|00005320| 6e 74 20 74 6f 20 64 65 | 66 69 6e 65 20 61 73 20 |nt to de|fine as |
|00005330| 74 68 65 20 4f 42 4a 45 | 43 54 49 56 45 20 63 65 |the OBJE|CTIVE ce|
|00005340| 6c 6c 2e 00 34 20 20 20 | 32 29 20 20 43 68 6f 6f |ll..4   |2)  Choo|
|00005350| 73 65 20 22 44 65 66 69 | 6e 65 20 4f 62 6a 65 63 |se "Defi|ne Objec|
|00005360| 74 69 76 65 22 20 66 72 | 6f 6d 20 74 68 65 20 43 |tive" fr|om the C|
|00005370| 65 6c 6c 20 6d 65 6e 75 | 2e 00 3e 52 45 4d 45 4d |ell menu|..>REMEM|
|00005380| 42 45 52 3a 20 20 59 6f | 75 72 20 4f 42 4a 45 43 |BER:  Yo|ur OBJEC|
|00005390| 54 49 56 45 20 63 65 6c | 6c 20 6d 75 73 74 20 63 |TIVE cel|l must c|
|000053a0| 6f 6e 74 61 69 6e 20 61 | 20 6c 69 6e 65 61 72 20 |ontain a| linear |
|000053b0| 66 6f 72 6d 75 6c 61 2e | 20 39 20 20 20 20 20 20 |formula.| 9      |
|000053c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000053d0| 28 73 65 65 20 22 4c 69 | 6e 65 61 72 69 74 79 22 |(see "Li|nearity"|
|000053e0| 20 6f 6e 20 74 68 65 20 | 48 45 4c 50 20 6d 65 6e | on the |HELP men|
|000053f0| 75 29 2e 00 00 01 cb 00 | 0c 3a 41 66 74 65 72 20 |u)......|.:After |
|00005400| 79 6f 75 20 68 61 76 65 | 20 69 64 65 6e 74 69 66 |you have| identif|
|00005410| 69 65 64 20 74 68 65 20 | 41 64 6a 75 73 74 61 62 |ied the |Adjustab|
|00005420| 6c 65 2c 20 43 6f 6e 73 | 74 72 61 69 6e 74 2c 20 |le, Cons|traint, |
|00005430| 61 6e 64 20 36 4f 62 6a | 65 63 74 69 76 65 20 43 |and 6Obj|ective C|
|00005440| 65 6c 6c 73 2c 20 79 6f | 75 20 61 72 65 20 72 65 |ells, yo|u are re|
|00005450| 61 64 79 20 74 6f 20 4f | 70 74 69 6d 69 7a 65 20 |ady to O|ptimize |
|00005460| 79 6f 75 72 20 6d 6f 64 | 65 6c 2e 00 2e 5f 5f 5f |your mod|el...___|
|00005470| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005480| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005490| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 0c 54 6f 20 4f |________|___.To O|
|000054a0| 50 54 49 4d 49 5a 45 3a | 00 3b 43 68 6f 6f 73 65 |PTIMIZE:|.;Choose|
|000054b0| 20 22 4d 61 78 69 6d 69 | 7a 65 22 20 6f 72 20 22 | "Maximi|ze" or "|
|000054c0| 4d 69 6e 69 6d 69 7a 65 | 22 20 66 72 6f 6d 20 74 |Minimize|" from t|
|000054d0| 68 65 20 4f 50 54 49 4d | 49 5a 41 54 49 4f 4e 20 |he OPTIM|IZATION |
|000054e0| 6d 65 6e 75 2e 2e 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |menu..__|________|
|000054f0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005500| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005510| 5f 5f 5f 5f 00 43 41 20 | 64 69 61 6c 6f 67 20 62 |____.CA |dialog b|
|00005520| 6f 78 20 77 69 6c 6c 20 | 61 70 70 65 61 72 2c 20 |ox will |appear, |
|00005530| 64 69 73 70 6c 61 79 69 | 6e 67 20 74 68 65 20 62 |displayi|ng the b|
|00005540| 65 73 74 20 61 6e 73 77 | 65 72 20 61 73 20 69 74 |est answ|er as it|
|00005550| 20 69 73 20 62 65 69 6e | 67 41 63 61 6c 63 75 6c | is bein|gAcalcul|
|00005560| 61 74 65 64 2e 20 20 59 | 6f 75 20 6d 61 79 20 73 |ated.  Y|ou may s|
|00005570| 74 6f 70 20 74 68 65 20 | 6f 70 74 69 6d 69 7a 61 |top the |optimiza|
|00005580| 74 69 6f 6e 20 70 72 6f | 63 65 73 73 20 61 74 20 |tion pro|cess at |
|00005590| 61 6e 79 20 74 69 6d 65 | 20 62 79 26 63 6c 69 63 |any time| by&clic|
|000055a0| 6b 69 6e 67 20 74 68 65 | 20 22 53 74 6f 70 22 20 |king the| "Stop" |
|000055b0| 62 75 74 74 6f 6e 20 69 | 6e 20 74 68 65 20 62 6f |button i|n the bo|
|000055c0| 78 2e 00 00 04 bf 00 17 | 3c 42 65 73 74 20 41 6e |x.......|<Best An|
|000055d0| 73 77 65 72 aa 20 6d 61 | 79 20 62 65 20 72 75 6e |swer. ma|y be run|
|000055e0| 20 63 6f 6e 63 75 72 72 | 65 6e 74 6c 79 20 77 69 | concurr|ently wi|
|000055f0| 74 68 20 45 78 63 65 6c | 20 75 73 69 6e 67 20 65 |th Excel| using e|
|00005600| 69 74 68 65 72 3e 53 77 | 69 74 63 68 65 72 20 6f |ither>Sw|itcher o|
|00005610| 72 20 4d 75 6c 74 69 46 | 69 6e 64 65 72 20 74 6f |r MultiF|inder to|
|00005620| 20 69 6e 63 72 65 61 73 | 65 20 74 68 65 20 65 66 | increas|e the ef|
|00005630| 66 69 63 69 65 6e 63 79 | 20 6f 66 20 63 72 65 61 |ficiency| of crea|
|00005640| 74 69 6e 67 42 61 6e 64 | 20 6f 70 74 69 6d 69 7a |tingBand| optimiz|
|00005650| 69 6e 67 20 6d 6f 64 65 | 6c 73 2e 20 20 57 68 65 |ing mode|ls.  Whe|
|00005660| 6e 20 72 75 6e 6e 69 6e | 67 20 69 6e 20 6f 6e 65 |n runnin|g in one|
|00005670| 20 6f 66 20 74 68 65 73 | 65 20 65 6e 76 69 72 6f | of thes|e enviro|
|00005680| 6e 6d 65 6e 74 73 2c 40 | 79 6f 75 20 63 61 6e 20 |nments,@|you can |
|00005690| 68 61 76 65 20 74 68 65 | 20 73 61 6d 65 20 66 69 |have the| same fi|
|000056a0| 6c 65 20 6f 70 65 6e 20 | 69 6e 20 62 6f 74 68 20 |le open |in both |
|000056b0| 70 72 6f 67 72 61 6d 73 | 2c 20 6d 61 6b 69 6e 67 |programs|, making|
|000056c0| 20 63 68 61 6e 67 65 73 | 3e 69 6e 20 45 78 63 65 | changes|>in Exce|
|000056d0| 6c 20 61 6e 64 20 6f 70 | 74 69 6d 69 7a 69 6e 67 |l and op|timizing|
|000056e0| 20 69 6e 20 42 65 73 74 | 20 41 6e 73 77 65 72 aa | in Best| Answer.|
|000056f0| 2e 20 20 54 6f 20 61 6c | 6c 6f 77 20 6f 6e 65 20 |.  To al|low one |
|00005700| 70 72 6f 67 72 61 6d 38 | 74 6f 20 61 63 63 65 73 |program8|to acces|
|00005710| 73 20 63 68 61 6e 67 65 | 73 20 6d 61 64 65 20 69 |s change|s made i|
|00005720| 6e 20 74 68 65 20 6f 74 | 68 65 72 2c 20 66 6f 6c |n the ot|her, fol|
|00005730| 6c 6f 77 20 74 68 65 73 | 65 20 73 74 65 70 73 3a |low thes|e steps:|
|00005740| 00 41 20 20 31 29 20 20 | 53 61 76 65 20 74 68 65 |.A  1)  |Save the|
|00005750| 20 73 70 72 65 61 64 73 | 68 65 65 74 20 62 79 20 | spreads|heet by |
|00005760| 63 68 6f 6f 73 69 6e 67 | 20 22 53 61 76 65 22 20 |choosing| "Save" |
|00005770| 66 72 6f 6d 20 74 68 65 | 20 46 69 6c 65 20 4d 65 |from the| File Me|
|00005780| 6e 75 2e 22 20 20 32 29 | 20 20 53 77 69 74 63 68 |nu."  2)|  Switch|
|00005790| 20 74 6f 20 74 68 65 20 | 6f 74 68 65 72 20 70 72 | to the |other pr|
|000057a0| 6f 67 72 61 6d 2e 42 20 | 20 33 29 20 20 43 6c 6f |ogram.B | 3)  Clo|
|000057b0| 73 65 20 61 6e 64 20 74 | 68 65 6e 20 72 65 2d 6f |se and t|hen re-o|
|000057c0| 70 65 6e 20 74 68 65 20 | 63 68 61 6e 67 65 64 20 |pen the |changed |
|000057d0| 66 69 6c 65 20 28 49 6e | 20 42 65 73 74 20 41 6e |file (In| Best An|
|000057e0| 73 77 65 72 aa 20 79 6f | 75 35 20 20 20 20 20 20 |swer. yo|u5      |
|000057f0| 20 20 20 63 61 6e 20 75 | 73 65 20 74 68 65 20 22 |   can u|se the "|
|00005800| 52 65 76 65 72 74 22 20 | 63 6f 6d 6d 61 6e 64 20 |Revert" |command |
|00005810| 61 73 20 61 20 73 68 6f | 72 74 63 75 74 29 2e 00 |as a sho|rtcut)..|
|00005820| 42 55 73 69 6e 67 20 4d | 75 6c 74 69 46 69 6e 64 |BUsing M|ultiFind|
|00005830| 65 72 20 72 65 71 75 69 | 72 65 73 20 61 20 6c 6f |er requi|res a lo|
|00005840| 74 20 6f 66 20 6d 65 6d | 6f 72 79 20 28 61 74 20 |t of mem|ory (at |
|00005850| 6c 65 61 73 74 20 6f 6e | 65 20 6d 65 67 61 62 79 |least on|e megaby|
|00005860| 74 65 29 30 77 68 69 63 | 68 20 6d 61 79 20 72 75 |te)0whic|h may ru|
|00005870| 6c 65 20 6f 75 74 20 4d | 75 6c 74 69 46 69 6e 64 |le out M|ultiFind|
|00005880| 65 72 20 66 6f 72 20 6c | 61 72 67 65 20 6d 6f 64 |er for l|arge mod|
|00005890| 65 6c 73 2e 00 3e 55 73 | 69 6e 67 20 53 77 69 74 |els..>Us|ing Swit|
|000058a0| 63 68 65 72 20 72 65 71 | 75 69 72 65 73 20 6c 65 |cher req|uires le|
|000058b0| 73 73 20 6d 65 6d 6f 72 | 79 20 62 75 74 20 69 73 |ss memor|y but is|
|000058c0| 20 6e 6f 74 20 61 6c 77 | 61 79 73 20 72 65 6c 69 | not alw|ays reli|
|000058d0| 61 62 6c 65 3c 77 69 74 | 68 20 74 68 65 20 6e 65 |able<wit|h the ne|
|000058e0| 77 65 72 20 73 79 73 74 | 65 6d 20 73 6f 66 74 77 |wer syst|em softw|
|000058f0| 61 72 65 2e 20 20 28 4e | 6f 74 65 3a 20 41 70 70 |are.  (N|ote: App|
|00005900| 6c 65 20 68 61 73 20 6f | 66 66 69 63 69 61 6c 6c |le has o|fficiall|
|00005910| 79 3c 64 69 73 63 6f 6e | 74 69 6e 75 65 64 20 53 |y<discon|tinued S|
|00005920| 77 69 74 63 68 65 72 20 | 61 6e 64 20 64 6f 65 73 |witcher |and does|
|00005930| 20 6e 6f 74 20 67 75 61 | 72 61 6e 74 65 65 20 69 | not gua|rantee i|
|00005940| 74 20 74 6f 20 77 6f 72 | 6b 20 77 69 74 68 3f 61 |t to wor|k with?a|
|00005950| 6e 79 20 63 75 72 72 65 | 6e 74 20 6f 72 20 66 75 |ny curre|nt or fu|
|00005960| 74 75 72 65 20 68 61 72 | 64 77 61 72 65 2f 73 79 |ture har|dware/sy|
|00005970| 73 74 65 6d 20 73 6f 66 | 74 77 61 72 65 20 63 6f |stem sof|tware co|
|00005980| 6e 66 69 67 75 72 61 74 | 69 6f 6e 73 2e 29 3f 42 |nfigurat|ions.)?B|
|00005990| 65 20 73 75 72 65 20 74 | 6f 20 75 73 65 20 74 68 |e sure t|o use th|
|000059a0| 65 20 6c 61 74 65 73 74 | 20 76 65 72 73 69 6f 6e |e latest| version|
|000059b0| 20 6f 66 20 53 77 69 74 | 63 68 65 72 2e 20 20 59 | of Swit|cher.  Y|
|000059c0| 6f 75 20 6d 61 79 20 75 | 73 65 20 74 68 65 3d 53 |ou may u|se the=S|
|000059d0| 77 69 74 63 68 65 72 20 | 73 65 74 20 74 68 61 74 |witcher |set that|
|000059e0| 20 63 6f 6d 65 73 20 6f | 6e 20 74 68 65 20 70 72 | comes o|n the pr|
|000059f0| 6f 67 72 61 6d 20 64 69 | 73 6b 20 6f 72 20 63 6f |ogram di|sk or co|
|00005a00| 6e 66 69 67 75 72 65 20 | 79 6f 75 72 40 6f 77 6e |nfigure |your@own|
|00005a10| 20 73 65 74 20 28 45 78 | 63 65 6c 20 73 68 6f 75 | set (Ex|cel shou|
|00005a20| 6c 64 20 62 65 20 74 68 | 65 20 66 69 72 73 74 20 |ld be th|e first |
|00005a30| 70 72 6f 67 72 61 6d 20 | 6c 6f 61 64 65 64 29 2e |program |loaded).|
|00005a40| 20 20 49 66 20 79 6f 75 | 20 68 61 76 65 37 70 72 |  If you| have7pr|
|00005a50| 6f 62 6c 65 6d 73 2c 20 | 74 72 79 20 75 73 69 6e |oblems, |try usin|
|00005a60| 67 20 4d 75 6c 74 69 46 | 69 6e 64 65 72 20 6f 72 |g MultiF|inder or|
|00005a70| 20 72 75 6e 6e 69 6e 67 | 20 73 74 61 6e 64 2d 61 | running| stand-a|
|00005a80| 6c 6f 6e 65 2e 00 00 01 | 62 00 0a 3a 42 65 73 74 |lone....|b..:Best|
|00005a90| 20 41 6e 73 77 65 72 aa | 20 73 75 70 70 6f 72 74 | Answer.| support|
|00005aa0| 73 20 6f 6e 6c 79 20 74 | 68 65 20 66 6f 6c 6c 6f |s only t|he follo|
|00005ab0| 77 69 6e 67 20 45 78 63 | 65 6c 20 66 75 6e 63 74 |wing Exc|el funct|
|00005ac0| 69 6f 6e 73 3a 20 00 13 | 20 20 20 20 a5 20 20 61 |ions: ..|    .  a|
|00005ad0| 64 64 69 74 69 6f 6e 20 | 28 2b 29 16 20 20 20 20 |ddition |(+).    |
|00005ae0| a5 20 20 73 75 62 74 72 | 61 63 74 69 6f 6e 20 28 |.  subtr|action (|
|00005af0| 2d 29 19 20 20 20 20 a5 | 20 20 6d 75 6c 74 69 70 |-).    .|  multip|
|00005b00| 6c 69 63 61 74 69 6f 6e | 20 28 2a 29 1b 20 20 20 |lication| (*).   |
|00005b10| 20 a5 20 20 64 69 76 69 | 73 69 6f 6e 20 28 2f 29 | .  divi|sion (/)|
|00005b20| 20 20 20 20 20 20 20 20 | 16 20 20 20 20 a5 20 20 |        |.    .  |
|00005b30| 73 75 6d 6d 61 74 69 6f | 6e 20 28 53 55 4d 29 3b |summatio|n (SUM);|
|00005b40| 20 20 20 20 20 20 20 20 | 4e 6f 74 65 3a 20 54 68 |        |Note: Th|
|00005b50| 65 20 53 55 4d 20 66 75 | 6e 63 74 69 6f 6e 20 69 |e SUM fu|nction i|
|00005b60| 6e 20 42 65 73 74 20 41 | 6e 73 77 65 72 aa 20 68 |n Best A|nswer. h|
|00005b70| 61 6e 64 6c 65 73 20 63 | 65 6c 6c 41 20 20 20 20 |andles c|ellA    |
|00005b80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 72 65 |        |      re|
|00005b90| 66 65 72 65 6e 63 65 73 | 20 69 6e 20 72 61 6e 67 |ferences| in rang|
|00005ba0| 65 73 3a 20 53 55 4d 28 | 41 31 3a 42 33 2c 43 35 |es: SUM(|A1:B3,C5|
|00005bb0| 3a 44 37 29 2c 20 62 75 | 74 20 6e 6f 74 2d 20 20 |:D7), bu|t not-  |
|00005bc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005bd0| 65 78 70 72 65 73 73 69 | 6f 6e 73 3a 20 53 55 4d |expressi|ons: SUM|
|00005be0| 28 41 31 2a 33 2c 41 32 | 2a 34 29 00 00 03 07 00 |(A1*3,A2|*4).....|
|00005bf0| 12 40 54 68 65 72 65 20 | 61 72 65 20 73 65 76 65 |.@There |are seve|
|00005c00| 72 61 6c 20 64 69 66 66 | 65 72 65 6e 74 20 62 75 |ral diff|erent bu|
|00005c10| 73 69 6e 65 73 73 20 73 | 69 74 75 61 74 69 6f 6e |siness s|ituation|
|00005c20| 73 20 74 68 61 74 20 63 | 61 6e 20 62 65 6e 65 66 |s that c|an benef|
|00005c30| 69 74 41 66 72 6f 6d 20 | 6f 70 74 69 6d 69 7a 61 |itAfrom |optimiza|
|00005c40| 74 69 6f 6e 2e 20 20 45 | 78 61 6d 70 6c 65 73 20 |tion.  E|xamples |
|00005c50| 69 6e 63 6c 75 64 65 3a | 20 20 4d 61 6e 75 66 61 |include:|  Manufa|
|00005c60| 63 74 75 72 69 6e 67 20 | 50 72 6f 64 75 63 74 20 |cturing |Product |
|00005c70| 4d 69 78 2c 40 53 63 68 | 65 64 75 6c 69 6e 67 2c |Mix,@Sch|eduling,|
|00005c80| 20 50 6f 72 74 66 6f 6c | 69 6f 20 53 65 6c 65 63 | Portfol|io Selec|
|00005c90| 74 69 6f 6e 2c 20 4d 65 | 64 69 61 20 42 75 79 69 |tion, Me|dia Buyi|
|00005ca0| 6e 67 2c 20 42 6c 65 6e | 64 69 6e 67 20 61 6e 64 |ng, Blen|ding and|
|00005cb0| 20 43 61 73 68 0e 46 6c | 6f 77 20 41 6e 61 6c 79 | Cash.Fl|ow Analy|
|00005cc0| 73 69 73 2e 00 3d 4f 6e | 20 74 68 65 20 70 72 6f |sis..=On| the pro|
|00005cd0| 67 72 61 6d 20 64 69 73 | 6b 20 79 6f 75 20 72 65 |gram dis|k you re|
|00005ce0| 63 65 69 76 65 64 2c 20 | 74 68 65 72 65 20 69 73 |ceived, |there is|
|00005cf0| 20 61 20 22 53 61 6d 70 | 6c 65 73 22 20 66 6f 6c | a "Samp|les" fol|
|00005d00| 64 65 72 41 63 6f 6e 74 | 61 69 6e 69 6e 67 20 73 |derAcont|aining s|
|00005d10| 69 78 20 64 69 66 66 65 | 72 65 6e 74 20 65 78 61 |ix diffe|rent exa|
|00005d20| 6d 70 6c 65 20 73 70 72 | 65 61 64 73 68 65 65 74 |mple spr|eadsheet|
|00005d30| 73 2e 20 20 54 68 65 20 | 6e 65 78 74 20 73 69 78 |s.  The |next six|
|00005d40| 20 48 45 4c 50 33 74 6f | 70 69 63 73 20 73 65 74 | HELP3to|pics set|
|00005d50| 20 75 70 20 74 68 65 20 | 62 61 73 69 63 20 73 63 | up the |basic sc|
|00005d60| 65 6e 65 72 69 6f 73 20 | 66 6f 72 20 65 61 63 68 |enerios |for each|
|00005d70| 20 65 78 61 6d 70 6c 65 | 2e 00 40 54 68 65 20 66 | example|..@The f|
|00005d80| 69 72 73 74 20 65 78 61 | 6d 70 6c 65 20 69 73 20 |irst exa|mple is |
|00005d90| 61 20 76 65 72 79 20 73 | 69 6d 70 6c 65 20 6d 6f |a very s|imple mo|
|00005da0| 64 65 6c 20 77 68 69 63 | 68 20 61 6c 6c 6f 77 73 |del whic|h allows|
|00005db0| 20 79 6f 75 20 74 6f 20 | 67 65 74 41 79 6f 75 72 | you to |getAyour|
|00005dc0| 20 66 65 65 74 20 77 65 | 74 2e 20 20 54 68 65 20 | feet we|t.  The |
|00005dd0| 6f 74 68 65 72 20 66 69 | 76 65 20 65 78 61 6d 70 |other fi|ve examp|
|00005de0| 6c 65 73 20 61 72 65 20 | 6d 6f 72 65 20 72 65 61 |les are |more rea|
|00005df0| 6c 69 73 74 69 63 20 6d | 6f 64 65 6c 73 37 6f 66 |listic m|odels7of|
|00005e00| 20 68 6f 77 20 79 6f 75 | 20 6d 69 67 68 74 20 75 | how you| might u|
|00005e10| 73 65 20 42 65 73 74 20 | 41 6e 73 77 65 72 aa 20 |se Best |Answer. |
|00005e20| 69 6e 20 79 6f 75 72 20 | 6f 77 6e 20 62 75 73 69 |in your |own busi|
|00005e30| 6e 65 73 73 2e 00 3c 54 | 68 65 73 65 20 65 78 61 |ness..<T|hese exa|
|00005e40| 6d 70 6c 65 20 73 70 72 | 65 61 64 73 68 65 65 74 |mple spr|eadsheet|
|00005e50| 73 20 77 69 6c 6c 20 73 | 65 72 76 65 20 62 6f 74 |s will s|erve bot|
|00005e60| 68 20 61 73 20 61 6e 20 | 65 64 75 63 61 74 69 6f |h as an |educatio|
|00005e70| 6e 61 6c 3c 74 6f 6f 6c | 20 61 6e 64 20 61 73 20 |nal<tool| and as |
|00005e80| 62 61 73 69 63 20 6d 6f | 64 65 6c 73 20 28 74 65 |basic mo|dels (te|
|00005e90| 6d 70 6c 61 74 65 73 29 | 20 66 6f 72 20 73 65 74 |mplates)| for set|
|00005ea0| 74 69 6e 67 20 75 70 20 | 79 6f 75 72 20 6f 77 6e |ting up |your own|
|00005eb0| 0d 73 70 72 65 61 64 73 | 68 65 65 74 73 2e 00 36 |.spreads|heets..6|
|00005ec0| 20 20 20 20 20 20 20 20 | 20 43 6c 69 63 6b 20 22 |        | Click "|
|00005ed0| 4e 45 58 54 22 20 74 6f | 20 72 65 61 64 20 61 62 |NEXT" to| read ab|
|00005ee0| 6f 75 74 20 74 68 65 20 | 66 69 72 73 74 20 65 78 |out the |first ex|
|00005ef0| 61 6d 70 6c 65 2e 00 00 | 05 24 00 24 40 59 6f 75 |ample...|.$.$@You|
|00005f00| 20 61 72 65 20 52 61 79 | 2c 20 74 68 65 20 66 72 | are Ray|, the fr|
|00005f10| 69 65 6e 64 6c 79 20 6e | 65 69 67 68 62 6f 72 68 |iendly n|eighborh|
|00005f20| 6f 6f 64 20 73 61 75 73 | 61 67 65 20 6d 61 6b 65 |ood saus|age make|
|00005f30| 72 2e 20 20 59 6f 75 20 | 6d 61 6b 65 20 42 66 69 |r.  You |make Bfi|
|00005f40| 76 65 20 64 69 66 66 65 | 72 65 6e 74 20 6b 69 6e |ve diffe|rent kin|
|00005f50| 64 73 20 6f 66 20 73 61 | 75 73 61 67 65 20 62 79 |ds of sa|usage by|
|00005f60| 20 63 6f 6d 62 69 6e 69 | 6e 67 20 73 61 75 73 61 | combini|ng sausa|
|00005f70| 67 65 20 63 61 73 69 6e | 67 73 20 77 69 74 68 20 |ge casin|gs with |
|00005f80| 2b 74 68 72 65 65 20 74 | 79 70 65 73 20 6f 66 20 |+three t|ypes of |
|00005f90| 6d 65 61 74 3a 20 76 65 | 61 6c 2c 20 70 6f 72 6b |meat: ve|al, pork|
|00005fa0| 20 61 6e 64 20 62 65 65 | 66 2e 20 20 00 40 45 61 | and bee|f.  .@Ea|
|00005fb0| 63 68 20 6e 69 67 68 74 | 20 79 6f 75 20 67 6f 20 |ch night| you go |
|00005fc0| 68 6f 6d 65 20 61 6e 64 | 20 70 6c 61 6e 20 74 68 |home and| plan th|
|00005fd0| 65 20 70 72 6f 64 75 63 | 74 69 6f 6e 20 73 63 68 |e produc|tion sch|
|00005fe0| 65 64 75 6c 65 20 66 6f | 72 20 74 68 65 20 0e 66 |edule fo|r the .f|
|00005ff0| 6f 6c 6c 6f 77 69 6e 67 | 20 64 61 79 2e 00 3b 53 |ollowing| day..;S|
|00006000| 68 6f 75 6c 64 20 79 6f | 75 20 6d 61 6b 65 20 32 |hould yo|u make 2|
|00006010| 35 30 20 62 72 61 74 77 | 75 72 73 74 2c 20 35 30 |50 bratw|urst, 50|
|00006020| 30 20 49 74 61 6c 69 61 | 6e 20 53 61 75 73 61 67 |0 Italia|n Sausag|
|00006030| 65 73 20 61 6e 64 20 37 | 38 35 3f 50 6f 6c 69 73 |es and 7|85?Polis|
|00006040| 68 20 53 61 75 73 61 67 | 65 73 3f 20 20 4f 72 20 |h Sausag|es?  Or |
|00006050| 77 6f 75 6c 64 20 69 74 | 20 62 65 20 62 65 74 74 |would it| be bett|
|00006060| 65 72 20 74 6f 20 66 6f | 72 67 65 74 20 74 68 65 |er to fo|rget the|
|00006070| 20 62 72 61 74 77 75 72 | 73 74 42 61 6c 74 6f 67 | bratwur|stBaltog|
|00006080| 65 74 68 65 72 20 61 6e | 64 20 75 73 65 20 75 70 |ether an|d use up|
|00006090| 20 74 68 65 20 72 65 73 | 74 20 6f 66 20 74 68 65 | the res|t of the|
|000060a0| 20 70 6f 72 6b 20 69 6e | 20 6d 61 6b 69 6e 67 20 | pork in| making |
|000060b0| 61 20 65 78 74 72 61 20 | 6c 61 72 67 65 3a 62 61 |a extra |large:ba|
|000060c0| 74 63 68 20 6f 66 20 70 | 65 70 70 65 72 6f 6e 69 |tch of p|epperoni|
|000060d0| 2c 20 61 6c 6c 6f 77 69 | 6e 67 20 74 68 65 20 76 |, allowi|ng the v|
|000060e0| 65 61 6c 20 74 6f 20 22 | 67 6f 20 74 6f 20 74 68 |eal to "|go to th|
|000060f0| 65 20 64 6f 67 73 22 3f | 00 28 59 4f 55 52 20 4d |e dogs"?|.(YOUR M|
|00006100| 49 53 53 49 4f 4e 3a 20 | 20 54 6f 20 4d 61 78 69 |ISSION: | To Maxi|
|00006110| 6d 69 7a 65 20 47 72 6f | 73 73 20 50 72 6f 66 69 |mize Gro|ss Profi|
|00006120| 74 21 00 24 54 68 69 73 | 20 69 73 20 77 68 65 72 |t!.$This| is wher|
|00006130| 65 20 42 65 73 74 20 41 | 6e 73 77 65 72 aa 20 63 |e Best A|nswer. c|
|00006140| 6f 6d 65 73 20 69 6e 2e | 00 2e 46 69 72 73 74 2c |omes in.|..First,|
|00006150| 20 6c 6f 61 64 20 74 68 | 65 20 73 70 72 65 61 64 | load th|e spread|
|00006160| 73 68 65 65 74 20 69 6e | 74 6f 20 42 65 73 74 20 |sheet in|to Best |
|00006170| 41 6e 73 77 65 72 aa 2e | 00 3d 54 68 65 6e 2c 20 |Answer..|.=Then, |
|00006180| 64 65 66 69 6e 65 20 79 | 6f 75 72 20 43 6f 6e 73 |define y|our Cons|
|00006190| 74 72 61 69 6e 74 20 63 | 65 6c 6c 73 2c 20 41 64 |traint c|ells, Ad|
|000061a0| 6a 75 73 74 61 62 6c 65 | 20 63 65 6c 6c 73 20 61 |justable| cells a|
|000061b0| 6e 64 20 79 6f 75 72 25 | 4f 62 6a 65 63 74 69 76 |nd your%|Objectiv|
|000061c0| 65 20 63 65 6c 6c 20 20 | 28 68 69 6e 74 3a 20 73 |e cell  |(hint: s|
|000061d0| 65 65 20 43 65 6c 6c 20 | 6d 65 6e 75 29 00 43 20 |ee Cell |menu).C |
|000061e0| 20 20 20 4e 4f 54 45 3a | 20 20 45 61 63 68 20 74 |   NOTE:|  Each t|
|000061f0| 79 70 65 20 6f 66 20 63 | 65 6c 6c 20 74 68 61 74 |ype of c|ell that|
|00006200| 20 6e 65 65 64 73 20 74 | 6f 20 62 65 20 64 65 66 | needs t|o be def|
|00006210| 69 6e 65 64 20 69 73 20 | 6c 61 62 65 6c 65 64 20 |ined is |labeled |
|00006220| 6f 6e 28 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |on(     |        |
|00006230| 20 20 20 74 68 65 20 65 | 78 61 6d 70 6c 65 20 73 |   the e|xample s|
|00006240| 70 72 65 61 64 73 68 65 | 65 74 3a 00 35 20 20 20 |preadshe|et:.5   |
|00006250| 20 20 20 20 20 20 20 a5 | 20 20 43 6f 6e 73 74 72 |       .|  Constr|
|00006260| 61 69 6e 74 73 20 61 72 | 65 20 22 69 6e 76 65 6e |aints ar|e "inven|
|00006270| 74 6f 72 79 20 72 65 6d | 61 69 6e 69 6e 67 22 2e |tory rem|aining".|
|00006280| 20 20 37 20 20 20 20 20 | 20 20 20 20 20 a5 20 20 |  7     |     .  |
|00006290| 41 64 6a 75 73 74 61 62 | 6c 65 73 20 61 72 65 20 |Adjustab|les are |
|000062a0| 74 68 65 20 22 71 75 61 | 6e 74 69 74 79 20 74 6f |the "qua|ntity to|
|000062b0| 20 70 72 6f 64 75 63 65 | 22 2e 2e 20 20 20 20 20 | produce|"..     |
|000062c0| 20 20 20 20 20 a5 20 20 | 4f 62 6a 65 63 74 69 76 |     .  |Objectiv|
|000062d0| 65 20 63 65 6c 6c 20 69 | 73 20 22 47 72 6f 73 73 |e cell i|s "Gross|
|000062e0| 20 50 72 6f 66 69 74 22 | 2e 00 36 46 69 6e 61 6c | Profit"|..6Final|
|000062f0| 6c 79 2c 20 63 68 6f 6f | 73 65 20 22 4d 61 78 69 |ly, choo|se "Maxi|
|00006300| 6d 69 7a 65 22 20 66 72 | 6f 6d 20 74 68 65 20 4f |mize" fr|om the O|
|00006310| 70 74 69 6d 69 7a 61 74 | 69 6f 6e 20 6d 65 6e 75 |ptimizat|ion menu|
|00006320| 2e 00 3c 56 6f 69 6c 61 | 21 20 20 42 65 73 74 20 |..<Voila|!  Best |
|00006330| 41 6e 73 77 65 72 aa 20 | 67 6f 65 73 20 74 6f 20 |Answer. |goes to |
|00006340| 77 6f 72 6b 2e 20 20 41 | 73 20 70 72 6f 6d 69 73 |work.  A|s promis|
|00006350| 65 64 2c 20 74 68 65 20 | 70 72 6f 67 72 61 6d 3c |ed, the |program<|
|00006360| 63 61 6c 63 75 6c 61 74 | 65 73 20 74 68 65 20 6f |calculat|es the o|
|00006370| 70 74 69 6d 61 6c 20 73 | 6f 6c 75 74 69 6f 6e 2e |ptimal s|olution.|
|00006380| 20 20 49 66 20 79 6f 75 | 20 73 65 74 20 75 70 20 |  If you| set up |
|00006390| 74 68 69 73 20 65 78 61 | 6d 70 6c 65 39 63 6f 72 |this exa|mple9cor|
|000063a0| 72 65 63 74 6c 79 2c 20 | 79 6f 75 72 20 6f 70 74 |rectly, |your opt|
|000063b0| 69 6d 69 7a 65 64 20 6f | 62 6a 65 63 74 69 76 65 |imized o|bjective|
|000063c0| 20 73 68 6f 75 6c 64 20 | 62 65 20 24 31 32 2c 37 | should |be $12,7|
|000063d0| 33 32 2e 32 35 2e 00 38 | 54 68 69 73 20 69 73 20 |32.25..8|This is |
|000063e0| 74 68 65 20 6d 61 78 69 | 6d 75 6d 20 70 72 6f 66 |the maxi|mum prof|
|000063f0| 69 74 20 79 6f 75 20 63 | 61 6e 20 6d 61 6b 65 20 |it you c|an make |
+--------+-------------------------+-------------------------+--------+--------+